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.
|
