AnsweredAssumed Answered

Unique and Repeat Record Issues

Question asked by Jerten81 on Jul 8, 2009
Latest reply on Jul 8, 2009 by mrvodka


Unique and Repeat Record Issues


I have a database where I look at sales transactions over a given time period with the following fields: Customer, Product Purchased, Date Purchased.  I want to be able to isolate only repeat customers during the month of June.  For example's sake let's say there were 20,000 sales in the month of June and 15,000 of those sales were one time customers.  I want to take an in depth look at the other 5,000 sales and figure out information such as: how many customers were responsible for those 5,000 purchases, how many customers bought two items (three items, four items etc.).  I can't seem to get my head around the best way to do this.  The unique record functions don't help me because they only tell me how many "unique" customers bought something in the month of June which is not what information I'm trying to get.  Any help/suggestions would be much appreciated.  Thanks.