Query won't list more than 25 records

[Scott]

I have a rather complex database written, that works
great for the first 25 records. After that, one of my
queries just stops adding records to the query. all of
the tables that the query draws from add records
appropriatly,but they do not show up in the query. I
have tried to check to see if there in a max number set
for the query, and there appears not to be one. I have
tried creating a report from the query, thinking it would
list all the records, but no luck, it just lists the 25.

Can you help please (my boss really likes the database,
but I can't release it to him with this glitch!)

Thank you.

 

[Bill Taylor]

Look at the last record it produces, and if possible the next record it
would select. See if data in one of these records is causing the problem.
Then remove one table at a time until you find the offender. This is a
process and not an easily solved problem. good luck.
HTH