Selecting Specific Rows to Display in a Query

This tip explains how to display every 5th record in a table.  For example; you have a table with many records. The first field in each of the records is where you number each record. Each record has a unique number. You wish to build a query which would only return records with these numbers: 1, 6, 11, 16, 21, 26, 31, and so on (every 5th record).

To do this:

In the criteria row of the query for the field that has the record numbers, type the following:

[FieldName] Mod 5 = 1

This will return all the fields that when divided by 5 have a remainder of 1.

NOTE: Change FieldName to the name of your field.


Do you like this tip? Subscribe to my free weekly Newsletter to receive tips weekly via email. Click Here to subscribe.