T
tim.burleson
Hello,
I am trying to build a query that will tell me the date a customer
crosses a predetermined threshold. I have an invoice table that
carries the invoice date and the amount invoiced among other things.
We would like to reward customers that do x amount of business with
us. How can I query a the invoice table to tell me what date each
customer has accumulated x amount of business.
For instance. I want to know when a customer goes over $10,000.00 in
business.
I am sorry if I am not using the right terms but hopefully I have come
close to expressing my question.
Your help is appreciated.
Thanks, Tim
I am trying to build a query that will tell me the date a customer
crosses a predetermined threshold. I have an invoice table that
carries the invoice date and the amount invoiced among other things.
We would like to reward customers that do x amount of business with
us. How can I query a the invoice table to tell me what date each
customer has accumulated x amount of business.
For instance. I want to know when a customer goes over $10,000.00 in
business.
I am sorry if I am not using the right terms but hopefully I have come
close to expressing my question.
Your help is appreciated.
Thanks, Tim