TravelerOn
Registered User.
- Local time
- Today, 14:51
- Joined
- Dec 17, 2001
- Messages
- 21
Question:
I have a query that returns 5,997 records from a larger table of 16,000 records. On the report, I only want to see 150 of that 5,997. How do I tell Access to only show me the first 150....so that my report isn't over 500 pages long?
Yes, I've tried setting the total records returned on the Query properties. It isn't working. Is there another method?
I have a query that returns 5,997 records from a larger table of 16,000 records. On the report, I only want to see 150 of that 5,997. How do I tell Access to only show me the first 150....so that my report isn't over 500 pages long?
Yes, I've tried setting the total records returned on the Query properties. It isn't working. Is there another method?