Is there a way to select every nth (say, every 3rd, or 5th, or 8th, etc) record from a table using a query?
The data are GPS positions, and I am using them to create an animation of vehicle motion. Selecting non-contiguous records allows me to speed up the animation. Presently I select every record in the base query, and then walk thru the resulting recordset using the recordset.MOVE N command in some VBA code. However this technique can miss significant records when more than one vehicle exists in the recordset. I figure that selecting the nth records prior to walking thru the recordset (and then displaying EVERY record from the query) would work better.
thanks for any help.
