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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access-query-calculate total of fields

Status
Not open for further replies.

yanqui

Technical User
Aug 19, 2002
70
US
We've looked at the book and help screens on this--we have three fields in a table that we want to total into another field. Do we do this in the table or in the query? What is the syntax?
 
Do you want to do it "per record"?
What's the output?
A form or report?
If so, THAT's where you do it.

Put a textbox on the form or report and change the Unbound to read: =[field1]+[field2]+[field3]



Anne Troy
Way cool stuff:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top