G
Guest
Is it possible to see the total of a column on the display screen of a query?
If so, how do you accomplish this?
If so, how do you accomplish this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
Queries return rows. If you want to see (only) a total, use a TOTALS query.
If you want to see the detailed row values and a total, use a report based
on the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
If you want to see the detailed row values and a total, use a report based
on the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
G
Guest
There is no way to have the column total actually print at the bottom of a
query column? I would like to see something similar to Excel's ability to
total a column, but still be able to use Access.
query column? I would like to see something similar to Excel's ability to
total a column, but still be able to use Access.
D
Duane Hookom
Normally this is done in a form or report. If you really want this in a
query, you may need to create a union query that unions the details and a
summary query.
query, you may need to create a union query that unions the details and a
summary query.
J
Jeff Boyce
It sounds like you want Access to behave like Excel. Could you export your
query to Excel and show the column totals there?
Regards
Jeff Boyce
Microsoft Office/Access MVP
query to Excel and show the column totals there?
Regards
Jeff Boyce
Microsoft Office/Access MVP