Calculate Totals

L

Lamar

I have a list of invoice charges in Report Header and want to sum the totals
of calculated textboxes.
So I want my report to individually calculate and show the amounts for each
charge in a text box (this is working fine). Then I want sum the totals in
all the text boxes.

=Sum([txtBasic]+[txtWorkYearsCharge]+[txtPostage]+[txtAddtCharge])

Thanks for any help. Lamar
 
S

strive4peace

Hi Lamar,

if the equations are in the report rather than the
RecordSource, you will need to repeat the equations in your
SUM control instead of referring to the name of a calculated
control.


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top