Limiting repeats of customers name in data.

[robtscot]

Just starting so am a little embarrased by what is very obvious to forum users.

I have a data base.
I want to take the fields
Customer............... Purchase Value ............ Date of purchase

For a period where the customer has returned to the point of sale and has made
multiple purchases I have been able to choose sales in any given week excluding
data outside of the range. Have been able to sum all of the sales within that period. I get my result on one line e.g. $1232.74.
What I cannot do is reduce the customers name to one line i.e. I get with 8 sales 8 repititions. Have tried using "group" without success . Can I do this within Query and shrink/summarise Alphbetical data in the same manner as numerical data or do I need to go to reports??
Thanking you in anticipation
Rob

 

[Rabbie]

Is your data normalised. For what you describe you probaly need 3 tables.

1. tblCustomer
CustomerID(Primary key)
customer details (name,address, etc)
2. tblPurchases
PurchaseID(Primary Key)
CustomerID(Foreign Key)
date of purchase etc.
3. tblPurchaseDetails
PurchaseDetailId(primary Key)
PurchaseID(Foreign Key)
QuantityPurchased
ItemPurchased
UnitPrice
etc

Hope this helps