Incrementing report items

[angelac]

I need to generate a report that provides a list of ten units that need testing. I have no trouble with the report but how do I get it to increment to the next ten once those have been tested. I am so new to Access and have only done one course. I'm on a work term now that's all Access and I'd really appreciate all the help I can get.

 

[Chris RR]

OK, can I assume that you are using a top values query to get the first 10? And also that there is some flag or other value that you are checking to see if a unit needs testing? Then, assuming that the users update that value, your next run of the top values query would give you the next ten records.

If you want all records needing testing at once (with no update in between) couldn't you create a report with ten records per page, then have the user work page by page?

 

[angelac]

The second way would be okay. How do I get only 10 records on a page. I told you I was new at this...