Records

[nashr1928]

This may seem dumb but what would cause my queries to have less number of records than the tables they get the data from?



I am using XP-Pro and access 2003.

[pbaldy]

Either a criteria in the query or a join if there are multiple tables in the query. With the wrong join, if you have tables with 50 and 100 records respectively, the query might only return the 50 records that have a common key value. More info on your situation would help.

[nashr1928]

I got it. I just created a new report and it works. I must have skipped something before. Thanks for all your help.

[pbaldy]

Glad you got it sorted out.