Hope someone could help me with this! In my customertbl, I have 2 fields that i use to run my query..
[OrderDate] & [BillingDate]. First payment is due 14 days from[OrderDate]and this will automatically update[BillingDate]with Date().From there I bill a customer every 30 days from the [BillingDate]at the same time that same feild gets updated every time i bill a customer.
Now,I would like to run a query the counts how many times each customer should have been billed. Is this possible!!!
I tried everything.. Thanks in advance.
[OrderDate] & [BillingDate]. First payment is due 14 days from[OrderDate]and this will automatically update[BillingDate]with Date().From there I bill a customer every 30 days from the [BillingDate]at the same time that same feild gets updated every time i bill a customer.
Now,I would like to run a query the counts how many times each customer should have been billed. Is this possible!!!
I tried everything.. Thanks in advance.