Union query retrieves 1000 records only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I made a union query that I then display as a cross tab. It seemed to run
normally but the figures didn't look right. By running the query only, I
realized that it only retrieves 1000 rows. Is there some settings that I need
to change?
Thanks as always,
Kanga
 
Kanga said:
I made a union query that I then display as a cross tab. It seemed to run
normally but the figures didn't look right. By running the query only, I
realized that it only retrieves 1000 rows. Is there some settings that I need
to change?
Click to expand...


Access has no limit that would do that.

Maybe your query is filtering out some data that you didn't
think it would?? E.g. maybe you need UNION ALL instead of
UNION
 
Back
Top