G
Guest
Has anyone run into this before & have a solution? Using Access v2003, v2000
database.
Have 2 separate queries that when run independently return 40 & 221 rows
respectively. I am not summing, although each is a select query based upon a
summed/grouped query linked back to their source to report "duplicate lines"
based upon record count.
I need to "stack" the results of each, so tried a straight union of the two...
SELECT * FROM [Query1] UNION SELECT * FROM [Query2]; instead of the expected
261 rows I end up w/ only 166. I have also tried creating a union based upon
the full SQL code behind each of the 2 queries, no luck. On the off chance
that it might be a connectivity problem (front end on PC, data on server) I
copied the data tables to my local machinne, re-linked to the local tables &
tried again... still only 166 lines returned. I changed the ODBC timeout from
60 to 300 & I have also run compact/repair on each of the MDB files. Still no
luck & I am at my wits end!
database.
Have 2 separate queries that when run independently return 40 & 221 rows
respectively. I am not summing, although each is a select query based upon a
summed/grouped query linked back to their source to report "duplicate lines"
based upon record count.
I need to "stack" the results of each, so tried a straight union of the two...
SELECT * FROM [Query1] UNION SELECT * FROM [Query2]; instead of the expected
261 rows I end up w/ only 166. I have also tried creating a union based upon
the full SQL code behind each of the 2 queries, no luck. On the off chance
that it might be a connectivity problem (front end on PC, data on server) I
copied the data tables to my local machinne, re-linked to the local tables &
tried again... still only 166 lines returned. I changed the ODBC timeout from
60 to 300 & I have also run compact/repair on each of the MDB files. Still no
luck & I am at my wits end!