Spreadsheet-like look

P

prana1

Hi all,

If I have query that gives with the following four lines, how could I add a
last line, of totals?

Name Amount
Bob 50
Carl 60
Don 70
-----------------
Total 180

The first 4 lines are easy - they come from a query.

Any idears?
 
B

BruceM

You could do it readily enough in a form or report based on the query.
Place an unbound text box in the form footer, or in a group or report footer
on a report, with something like this as the Control Source:
=Sum([SalesAmount])

By the way, if Name is a field name, consider changing it, as it is a
reserved word. If you do not change it you need to be sure to place square
brackets around every reference to the field so that Access doesn't think
you're trying to reference the Name property.
 
Top