Hi
The task i have to to produce a report showing 12 months, and a year to date running total.
That only counts the number of customers who have placed an order in the 1st month of year.
The next month should only then count customers (that were not counted last time) that have placed an order in the 2nd month, (but not the first) and so on, so each month, is a count of new customers, that were not counted before, the year to date is also a running total of customers we are dealing with.
example
customers delt with in period 1.
200
customers delt with in period 2.
180 (these will not be the same customers as in period 1.
year to date
no of customser delt with all year
380
Can you help.
Janet Anderson
Management Information
The task i have to to produce a report showing 12 months, and a year to date running total.
That only counts the number of customers who have placed an order in the 1st month of year.
The next month should only then count customers (that were not counted last time) that have placed an order in the 2nd month, (but not the first) and so on, so each month, is a count of new customers, that were not counted before, the year to date is also a running total of customers we are dealing with.
example
customers delt with in period 1.
200
customers delt with in period 2.
180 (these will not be the same customers as in period 1.
year to date
no of customser delt with all year
380
Can you help.
Janet Anderson
Management Information