Queries and Sums

[mrchinchin25]

If I have a query that is returning the following fields:
Part No,
Demand*Setup

how can I get the Sum of Demand*Setup for different Part No.s???

eg.

Part No Demand*Setup Part Total
X 4 6
X 2 6
Y 6 8
Y 2 8

ie. Part No X has a total of 6.
Part No Y has a total of 8.

DSum is just going to bring back the entire sum of the query (in this case 6+6+8+8 = 28).

any ideas???

 

[fredk]

If I understand this correctly.....

Can you base another query off your current query and just use the totals:

Part No - Group By
Demand*Setup - Sum

Would that work for you?

Fred

 

[jebry]

Hi!

Use the following SQL:

Select [Part No], Sum([Demand*Setup]) As SetupTotal From YourTable Group By [Part No]

hth
Jeff Bridgham
bridgham@purdue.edu