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

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
 
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

Similar Threads

how can I caclulate the sum of a sum in a report? 2
i have to remove textbox name 3
A03 - count in report footer gives me #Error? 0
How to Sum Total cost field in report 2
Access 2003:how to calculate percentages in a report 1
Counting how many records have writing in two columns. 1
Adding Criteria to Access Reports 2
Report Calculation 2

Top