Querying every third record

[rickorsteve]

I'm trying to query every third record from table a in order to add it to another table b.
I could use some help as soon as possible.

 

[nabiS2K]

What kind of data does the table contain?

 

[rickorsteve]

it is an excel file that i need to sort in access by every third name. I have given each record a numerical value ( 1-13000). Now I need to grab every third record 1-3-6-9-12 etc?
Any thoughts?

 

[nabiS2K]

Yes... You will want to add this to the WHERE clause of the query...

([YourLineNumberField]/3 = Int(YourLineNumberField/3))

This will only choose rows that are evenly divisable by 3.

If you want to include row one as well. Just add another item that says:

Or ([YourLineNumberField] = 1)

Feel free to post your SQL Statement for help if you run into trouble.

 

[rickorsteve]

Thnaks it worked like a charm.I appreciate your help