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.