Query Counting

[alastair69]

Hello All,

This is a problem that i have had for a bit now and after using the search function on here, i am still no the waiser.

I have a query that i need to make a caluation on every 10th record, i would really like some help on this please.

Kind Regards

Alastair

 

[neileg]

How are you defining the 'tenth' record? What is giving you the order in your dataset?

 

[alastair69]

the ID colunm which is a autonumber