Access 2007 - getting every nth record from a query
Posted on 2009-03-30
I have a query with many conditions that returns 332 records (at this time.) I can use DCOUNT to count the number of records and then I divide that by 15, and the rounded number I get is 22. I now want to only show (or extract to another query) every 22nd record. I am having trouble with this seemingly easy part.
If I could get a field in the query that was simply the record #, I could then take only the records where the record # /22 is an integer. There are other ways as well, I'm sure. Maybe lack of sleep is preventin me from seeing this. Help would be greatly appreciated.