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