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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I want to add all fields in a row?????

Status
Not open for further replies.
gnibbles

gnibbles

Programmer
Mar 15, 2000
79
CA
I thought I could just add in this expression<br><br>=Sum([Local_Charges]+[Other_Charges]+[Total_Long_Distance]+[Misc]+[Tax]+[Adjustments])<br><br><br>but it didnt work it adds up the WHOLE table i want to just add up a single row.
 
Sort by date Sort by votes
SUM is an aggregate function.&nbsp;&nbsp;If you want the individual rows, don't use the SUM function.<br><br>=[Local_Charges]+[Other_Charges]+[Total_Long_Distance]+[Misc]+[Tax]+[Adjustments]<br><br><br><br><br> <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
967
renigar
renigar
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
376
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top