Through a query I've created a report with 95 records and the following fields: Profile_ID, Project_Name, Purpose and Obligated. I've been unsuccessful in grand totalling the "Obligated" field which represents funding per project. I know I need to put the calculated control in the report footer but I when I insert =sum([Obligated])using a text box control all I get is a '0' The "running sum" is toggled to "over-all." I think my problem may be related to the text box being unbound. Thanks in advance for any assistance with this question.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grand Total
- Thread starter LHume
- Start date
LonnieJohnson
Programmer
How is Obligated calculated? ljprodev@yahoo.com
Professional Development
MS Access Applications
Professional Development
MS Access Applications
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question