Union query retrieves 1000 records only

K

Kanga

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
 
M

Marshall Barton

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
 
Top