>I tried using 'MOD(RECNO(),3) = 0' in the WHERE clause and I think that will give me every 3rd record.


That will work but just remember two things.

1) That will look at the physical recno of the table and if that record is also elimited by a where or having clause that it will not get the record below it.

2) Selects with two tables that might not work so great. I've had trouble in the past with putting NOT DELETED() in the where clause with two tables and it not doing anything. I think VFP might create another join table for complated SQL and use the NOT DELETED() statement on the join table - just a guess.