ok so I had a problem on https://www.accessforums.net/queries...ery-55723.html and pbaldy helped out tremendously but now moving forward I have a new problem.
I have a few databases at different locations that I am trying to link into a central database so that the powers that be can see production totals, downtimes, efficiencies etc..
ok now so far everything is working until I tried using my union queries to create new queries, I get no results? I'm sure that since this is my first attempt at using union queries its something simple and right in front of me. here's what I've done-
1. used the union query to add the lineID(database location) to each of my tables.
2. since each locations unique id's start at "1" the unique id's could have duplicates across the locations so in the SQL of the union I trim'd the lineid with a few "0"'s with the unique id to create a new unique id. example, lineid 31 and unique id of 50 trims to "idshift"-3100050
it all looks great in the individual union queries for each of my 3 union queries when I run them. it pulls up all the locations tables and shows all their data perfectly just like a table would. then the problem starts, when I try to use the union queries together to show something like a shift date that is on the production shift query together with the products produced that is on the produced query I get nothing displaying. what are I not doing????