R ronnie_knight Dec 14, 2005 #1 I have a query that has a column that is an expression. Is there any way I can see a total for that column in the query?
I have a query that has a column that is an expression. Is there any way I can see a total for that column in the query?
J Joseph Meehan Dec 15, 2005 #2 I have a query that has a column that is an expression. Is there any way I can see a total for that column in the query? Click to expand... In design view click on the sum icon " ? "
I have a query that has a column that is an expression. Is there any way I can see a total for that column in the query? Click to expand... In design view click on the sum icon " ? "
P Pat Hartman\(MVP\) Dec 15, 2005 #3 Queries cannot show both detail and summary rows at the same time. If you want to see detail with a sum at the end, use a report.
Queries cannot show both detail and summary rows at the same time. If you want to see detail with a sum at the end, use a report.