That's a problem, more or less.
There's a fundamental problem, and that's that MS Access is a relational database. And the concept of a 'set' in that theory implies there's no sequence, so you can't speak of each fifth. So you have to impose a sequence yourself.
What I should do:
1. Make a copy (structure only) of the table.
2. In the copy, remove all primary key fields, and add a new field (type Counter) as new primary key.
3. Copy the old table into the new one (with a Add-query)
4. Make a query on the new table selecting all records where the last digit if the ID = 1 or 6 (use the mod operator).
You might need some experimenting and research, but this is the essence.
Hope this helps.
I am working with Access 2000 and am trying to get some data out of my database. Can anyone tell me how to create a report that will contain every 5th record? I am new to access and base on the little I know, I believe I have to use a query but how to go about it? Can anyone please help me?