I hope I am asking this in the correct forum.

I have a table with Year, Account Number, Customer Name and Spend. There are 6 years of data in the table. I need to write a query or queries to tell how many new customers were added each year.

So, 2004 will have a baseline number of customers, then how may were added in 2005, 2006, etc. BUT, if a customer was included in 2004, then dropped off for 2005, then came back in 2006 they are not considered new.

I can get the unique customer number by year, but then I'm kind of lost.

Any help with his would be greatly appreciated!!! Thanks.