Group Together Prices In a Query?

[Guest]

Hi Guys I have two tables, Orders and Order_Details which are queried in the
query below:

SELECT Orders.[Customer Name], Order_Details.OrderNumber,
Order_Details.Quantity, Order_Details.Price, Order_Details.ItemComplete,
[Quantity]*[Price] AS Total, Orders.Complete
FROM Order_Details INNER JOIN Orders ON Order_Details.OrderNumber =
Orders.OrderNumber
WHERE (((Orders.Complete)=No))
ORDER BY Orders.[Customer Name];


This query lists each customer with all their incomplete orders and the
quantity of goods ordered multiplied by the price of the item. Is there
anyway I can total up the TotalValue of orders for ecah customer?

So basically I'll want to see each customer's orders, the price and quantity
for each order, and then the total value of all their orders added up?

 

[Nikos Yannacopoulos]

Richard,

What you need is a report, not a query. Make a report on your existing
query, and use the grouping to get the customer totals; the report
wizard willl even take care of the totals for you.

HTH,
Nikos

 

[Guest]

Hello again Nikos, are you my guardian angel this week?

So that's why I couldn't get it working, I should be using a report.

One thing though, I'm not sure how to get my report to take care of the
totals, there doesn't seem to be an option to do this when running the wizard.

Richard,

What you need is a report, not a query. Make a report on your existing
query, and use the grouping to get the customer totals; the report
wizard willl even take care of the totals for you.

HTH,
Nikos

Hi Guys I have two tables, Orders and Order_Details which are queried in the
query below:

SELECT Orders.[Customer Name], Order_Details.OrderNumber,
Order_Details.Quantity, Order_Details.Price, Order_Details.ItemComplete,
[Quantity]*[Price] AS Total, Orders.Complete
FROM Order_Details INNER JOIN Orders ON Order_Details.OrderNumber =
Orders.OrderNumber
WHERE (((Orders.Complete)=No))
ORDER BY Orders.[Customer Name];


This query lists each customer with all their incomplete orders and the
quantity of goods ordered multiplied by the price of the item. Is there
anyway I can total up the TotalValue of orders for ecah customer?

So basically I'll want to see each customer's orders, the price and quantity
for each order, and then the total value of all their orders added up?

 

[Guest]

YEy I've got it working.

Just had a mental block that's all.

Thanks Nikos.

Richard,

What you need is a report, not a query. Make a report on your existing
query, and use the grouping to get the customer totals; the report
wizard willl even take care of the totals for you.

HTH,
Nikos

Hi Guys I have two tables, Orders and Order_Details which are queried in the
query below:

SELECT Orders.[Customer Name], Order_Details.OrderNumber,
Order_Details.Quantity, Order_Details.Price, Order_Details.ItemComplete,
[Quantity]*[Price] AS Total, Orders.Complete
FROM Order_Details INNER JOIN Orders ON Order_Details.OrderNumber =
Orders.OrderNumber
WHERE (((Orders.Complete)=No))
ORDER BY Orders.[Customer Name];


This query lists each customer with all their incomplete orders and the
quantity of goods ordered multiplied by the price of the item. Is there
anyway I can total up the TotalValue of orders for ecah customer?

So basically I'll want to see each customer's orders, the price and quantity
for each order, and then the total value of all their orders added up?

 

[Nikos Yannacopoulos]

Welcome!