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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding a total
- Thread starter TSO456
- Start date
Jill,
That's something that should be done in a report. If you base one of those on the query (without the total) you'll be able to add the total in a control on the footer. Check into sum and running sum in help for reports.
Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks
Take a look at the Developers' section of the site for some helpful fundamentals.
That's something that should be done in a report. If you base one of those on the query (without the total) you'll be able to add the total in a control on the footer. Check into sum and running sum in help for reports.
Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks
Take a look at the Developers' section of the site for some helpful fundamentals.
annsolomon
MIS
Like Jeremey, I usually do my totals in a report but if you truly only have a few fields in your query you could create a new field in the query with an alias and total all the fields: TotalFunds: A + B + C + D. I use that frequently when troubleshooting. Ann
- Status
Similar threads
- Locked
- Question