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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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])
 
Back
Top