Thanks JHB and Grumm.
How should i use 2 queries? i can find the biggest spender by using SUM on salesprice.
But how could i use another query to query the most popular product for THAT customer
JHB code gaves me the highest total QTY sum of the product
GRUMM code gaves me the highest QTY of...
Hi Grumm,
Thanks, it does give me the biggest spender. Customer B.
But it only shows the highest qty; (i had made append a line on to the table)
Customer total bought;
product 1001 = 30qty (1 x 10, 1 x 20)
product 4001 = 15qty
So it should show me the 1001 because customer bought the most qty...
Thanks Galaxiom!
when you mean group by productcode and customer, i can see which customer buy the highest qty of the product but how to get the most popular product for the highest sales customer?
Hi Gurus,
I have a table like this.
ProductCode, Qty, SalesPrice, Customer
1001 , 10 , $1000 , A
1001 , 10 , $1000 , B
2001 , 10 , $3000 , A
3001 , 15 , $3000 , A
4001 ...
Hi all MS Access Gurus,
I wanted to create a query to query which products have never been purchased in the year of 2014-2015.
I have a record of Sales order as below.
The sales order will has the below fields
ID Customer Date ProductCode Quantity
1 CustomerA 2/3/2012 1001 10
2...