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

Make a calculation expression based on sum fields in a query

Status
Not open for further replies.
dcorleto

dcorleto

MIS
May 19, 2002
82
US
I have a totals query that sums several fields. I would like to make an additional field that takes three existed "summed" fields and adds or subtracts the values in each. How might I go about this?
 
Sort by date Sort by votes
Code: 
SELECT SUM(a) SA, SUM(b) SB, SUM(c) SC,
 
       (SUM(a) + SUM(b) + SUM(c)) SABC

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
389
dhookom
dhookom
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
282
OzFoxy
OzFoxy
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
887
strongm
strongm
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
587
mikrom
mikrom
Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
462
rashmibala
R

Part and Inventory Search

Sponsor

Back
Top