Totals in Access queries

B

Becky W

I am having trouble creating totals in Access queries. I have read all the
help, but still cannot get the totals to appear on the View query. Can you
help?
 
M

[MVP] S.Clark

Select ID, Fieldname from tablename
Union
Select ID, Sum(Fieldname) from tablename group by ID
 
J

John Vinson

On Tue, 1 Nov 2005 12:36:14 -0800, "Becky W" <Becky
I am having trouble creating totals in Access queries. I have read all the
help, but still cannot get the totals to appear on the View query. Can you
help?
Click to expand...

No; not without some indication of what your table structure might be,
what you've tried, and what you're seeing vs. what you want to see.

Give us a bit of help here, please?

John W. Vinson[MVP]
 
B

Becky W

I have a query with a column of numbers that I want to total & print that
total at the bottom of the column - just like an Excel column. When I use
the "sum" in the design view, Access totals all the amounts by client & puts
that total in the number column.
Example
Client 1 $100.00
Client 2 200.00
Client 1 50.00

In this case it would see client1 = $150 & client 2 $200.00

But I want to see the total of $350.00 at the bottom of the column.
Hope this helps
 
J

John Vinson

I have a query with a column of numbers that I want to total & print that
total at the bottom of the column - just like an Excel column. When I use
the "sum" in the design view, Access totals all the amounts by client & puts
that total in the number column.
Example
Client 1 $100.00
Client 2 200.00
Client 1 50.00

In this case it would see client1 = $150 & client 2 $200.00

But I want to see the total of $350.00 at the bottom of the column.
Click to expand...

Queries are not spreadsheets, and they're not designed for printing or
for data presentation.

Create a Report instead, based on your table. Display the detail data
in the body of the report, and put a textbox on the report Footer with
a Control Source

=Sum([amountfield])


John W. Vinson[MVP]
 
Top