Totals in Access queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Select ID, Fieldname from tablename
Union
Select ID, Sum(Fieldname) from tablename group by ID
 
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]
 
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
 
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]
 
Back
Top