Re: Query won't list more than 25 records
From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04
- Next message: Bill Taylor: "Re: Save a filter (from table) as a query"
- Previous message: Bonnie: "Switch is overloaded!"
- In reply to: Scott: "Query won't list more than 25 records"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 19:29:23 GMT
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
"Scott" <anonymous@discussions.microsoft.com> wrote in message
news:5f2601c42dff$00740390$a401280a@phx.gbl...
> 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.
- Next message: Bill Taylor: "Re: Save a filter (from table) as a query"
- Previous message: Bonnie: "Switch is overloaded!"
- In reply to: Scott: "Query won't list more than 25 records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
