How do I Calculate a Sum in Access Report Design view?

N

NIcole Mary

I am preparing employees report for my class. Using Access report design
view i will like to be able to calculate the total salary, the 13%commisions,
the Total salary. I make the text box iwith those name in thereprt footer but
I can make it do the math function. Please help
Thank you
 
D

Duane Hookom

What did you try in the Control Source properties of the text boxes? Did you
look in Help or the sample Northwind database to see how to get totals in
report or group footers?


Generically, to sum a numeric field in a report, use an expression like:
=Sum([Numeric Field])
 

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