Date Account Opened Query

So, I can pull up the first invoice from every customer I have and the date on it is essentially the day the account was opened.

Is there any way for me to generate a report that will simply contain the info for the first sale for every customer? I would, of course, filter out all the info except for the date and use this to determine my account growth over the course of a couple of years.

My plan is to take this data into excel and make a chart showing monthly account gropwth over a 2 year period.

TIA

Andrew

Reply to
A
Loading thread data ...

List all invoices and sort them by customer and invoice date and export to excel and delete all invoices except the first one for each customer.

Reply to
Peter Saxton

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.