Union query retrieves 1000 records only

[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

 

[Marshall Barton]

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?

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

 

[Guest]

Thanks a lot! The Union All worked fixed the problem!
Kanga