report to list records 100 at a time

[ntambomvu]

Hello Everyone-
I am a novice programmer and trying my best.
thanks for the interaction- it is a great help when you chaps
are able to suggest solutions to problems that are not in the tutorials.
I have a stores table with 6000 records.
I am wanting to audit the contents of every store item. ( each item has its own
record in the table.)
Time constraints mean that i can only audit 100 records at a time so I want my report
to print out 100 records only.
I think that It would be nice to say to the report -" please print out record numbers between
101 and 200 " next time i will sat from 201 to 300 and so on.
Please give me suggestions as to how this could be easily done. ( maybe i need some
criteria in the query- or is there another way.


I dont fully understand the VBA coding yet - so a solution that can use the design
view interface would be easy for me

Best regards

fred evans from south africa

[CJ_London]

investigate using the TOP predicate in SQL e.g.

first 100 - SELECT TOP 100 * FROM myTable ORDER BY ID

second 100 - SELECT TOP 100 * FROM myTable WHERE ID NOT IN (SELECT TOP 100 * FROM myTable ORDER BY ID) ORDER BY ID

third 100 - SELECT TOP 100 * FROM myTable WHERE ID NOT IN (SELECT TOP 200 * FROM myTable ORDER BY ID) ORDER BY ID

ORDER BY is important because data is stored randomly. Without it, the same query might return different results each time it is run after updates have been made to the table

An alternative might be

SELECT * FROM myTable WHERE (SELECT Count(*) FROM myTable T WHERE ID<=myTable.ID) BETWEEN [Enter A Start number] AND [Enter a Start number]+99