Hello Everyone i am beginner to MS acces. My problem is I have a product table with different no. of purchase in different states like
Product States No.of Sales
Apple UK 3
Orange US 5
Apple US 6
Apple PK 5
I want to design a query with results like
Product State No. of Sales
Apple UK,US,PK 13
Orange US 5
Please Help