NeoPa,
Perhaps I can elaborate on my situation so that maybe you can give me an answer that I would understand.
I have 6 tables which are linked as so:
[imgnothumb]http://i44.tinypic.com/2n74gso.jpg[/imgnothumb]

Here are my queries:
[imgnothumb]http://i40.tinypic.com/16kzz2d.jpg[/imgnothumb]
As you can see I have a query that's called "Number of Orders a Customer has made". This query includes...

I've made an ordering system which includes a query that counts how many orders each individual customer has made.

Every 5 Orders a customer gets a discount on their order. How do I apply this?

Is there a function in access that recounts values? For example, access would count all a customers orders. Once that customer reaches 6 orders the query would automatically change the value to 1 and start recounting again. Can...