Trying to Include A Total in Report in Access

[Skins64]

I have multiple Companies and a revenue for each, in my report I need to include the sum of all revenues at bottom...do I use a text box, if so, how do I make it add all of the revenue...please help....thanks!

 

[Golom]

Select Company, SUM(Revenue) As TotalRevenue
From myTable
Group By Company

UNION

Select "ALL Companies", SUM(Revenue)
From myTable

 

[dhookom]

You should be able to add a text box to the Report Footer Section with a control source like:
=Sum([Revenue])

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]