To create query that returns every other record, use the MOD function of 2 applied to the relative record number to return a 1 for odd numbers and 0 for even numbers.
Setting a condition of
MOD( RRN( Your_Table ), 2 ) = 0 will return only even numbered records
Last Modified On:
No, open a new Support Case
You don't have the appropriate permissions.