Function

  • Thread starter Thread starter Kristie
  • Start date Start date
K

Kristie

In my query I have 3 columns
Division - Firm Pledge - Employee Pledge
There are several divisions and I would like to see the total sum of the
Firm Pledge Column and then Employee Pledge column and then another total of
the 2 columns together
So it looked something like this
Division Firm Pledge Employee Pledge
NEW TOTAL COLUMN
AG 200,000
200,000
LE 5,000
300,000 305,000
hot100 11,000
25,000 36,000
hot100*
2,000 2,000
216,000
327,000 How do I get this-> 543,000


Thanks for your help - if you need further explanation please let me know.
 
There are several divisions and I would like to see the total sum of the
Firm Pledge Column and then Employee Pledge column and then another total of
the 2 columns together
Click to expand...

Don't do this in a Query - do it in a Form (for onscreen viewing) or a
Report (for printing). In the Footer of the form or report put three
textboxes, with names and control sources of

txtTotFirm: =Sum([Firm Pledge])
txtTotEmp: =Sum([Employee Pledge])
txtGrandTot: =[txtTotFirm] + [txtTotEmp]
 
Back
Top