Ok All,

Here's the deal. I've have to figure out some logic that will basically only return every fifth record from a table. I have two fields in this table New Sales Calls and Reorder Calls. They are number fields. Basically, what I want the query to do is look at these two fields and determine starting from record one for that particular agent through to the last record for that particular agent and only return every fifth record. Basically, for each record there will be one new sales call or one reorder call. There won't be a time when they are the same. So both fields have to be taken into consideration. In other words my first two records might be new sales and the next three will be reorders. The fifth record in this case would pull the reorder since it's the fifth record. I hope I'm making sense. Thanks for any help.