Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
RECORD CUT OFF FOR A REPORT
- Thread starter cmurray78
- Start date
It sounds like you might want to use filters. Have you tried reading up on those?
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
- Thread starter
- #3
yes i have tried using a filter but with no luck
i want to set a filter thats says:
SELECT* FROM MyTable WHERE RecordCount < 20............ where recordCount is the number of records i want to see in my report
is there any way to do this?
i want to set a filter thats says:
SELECT* FROM MyTable WHERE RecordCount < 20............ where recordCount is the number of records i want to see in my report
is there any way to do this?
Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
Try setting a counter and looping through it extracting one record at a time. If you Table has an auto Number on a field all the better.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question