How do I add two sums in access?

K

Kats

I am creating Invoices for work...I have a "Previous Balance" amout added to
"Expense Item Amount" to get an employee total. I have all my emloyees on
this report and at the end I want to see a total of all "employee total". I
can't seem to get the total to equal the right amount. I tried everything I
know. Can anyone please help?
 
A

Arvin Meyer

Kats said:
I am creating Invoices for work...I have a "Previous Balance" amout added to
"Expense Item Amount" to get an employee total. I have all my emloyees on
this report and at the end I want to see a total of all "employee total". I
can't seem to get the total to equal the right amount. I tried everything I
know. Can anyone please help?
Click to expand...

In the report's footer, add a textbox and make its controlsource:

=Sum([TheFieldYouWantToTotal])

If you already have this total, and need to add them together, just add the
2 textboxes by NAME (not fieldname, use the control's name)

=([Forms]![ThisFormName]![TextBox1]+[Forms]![ThisFormName]![TextBox2])

If you have Nulls that cause a #Error, try this code:

http://www.mvps.org/access/reports/rpt0007.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top