Is there a way I can use a view from access and an excel spreadsheet in a label without joining them (I cant as there is no common data).
I can connect to the access database no problem but what I want to do is run a query prompt which looks up data in the other excel database and returns the value in a QR code.
I have them running independently, the access one adds in different field data in different positions on the label template and the other picks up an rfid tag in a query prompt as a keyboard entry and looks up the persons name in the excel spreadsheet and adds it to a QR code.
What I need to do is combine the two to produce my desired label.
Hope I have explained clear enough.