Summing Data

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

HI,

Can you write an expression in a query that sums up all
the records so I can create a grand total with in the
query? For example;

Name Total Grand Total
Test $1 5
AA $3 5
BB $1 5

So the individual records total to 5 and I want the Grand
total next to all the records.

Can this be done?
 
If I understand you correctly, try the following SQL.

=========================================================
SELECT YourTable1.Name, YourTable1.Total, (select sum
(Total) from YourTable1) AS GrandTotal
FROM YourTable1;
=========================================================
 
Hi JL,

I have a somewhat similar problem.

I have a query where if you give the code(Ex: BA01) it
brings up matching descriptions and the price for each of
them.

Code Description Price
BA01 AAA $0.87
BA01 BBB $0.22

I would like the 'descriptions' to be next to each other
and the 'total price' like below:

Code Description Price
BA01 AAA + BBB $1.09

Is there a way to do this?

Thanks.
 
Back
Top