sum by group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I added an extra column in my report that is not in the original database,
that gives me a whole total for the week, (adding across and I was able to do
an =sum in the control box that gave me the correct answer), is there a way
to get a complete total at the end of my report even though this is a new
column? I keep getting an error.

Thanks,
 
Pammy said:
If I added an extra column in my report that is not in the original database,
that gives me a whole total for the week, (adding across and I was able to do
an =sum in the control box that gave me the correct answer), is there a way
to get a complete total at the end of my report even though this is a new
column?
Click to expand...


You are probably getting the error because you tried to use
a control name in the sum function. All the aggregate
functions only understand **field** names in the record
source table/query.

If you are getting the correct total in the group
header/footer, then you can use the identical expression in
the report header/footer.
 
Marshall is correct. If you want to get a total across a line of controls,
it is a bit tedious, but you can add them together in the control source of
the text box you want them to display in"
=[txtSun]+[txrMon]+[txtTue]+[txtWed]+[txtThr]+[txtFri]+[txtSat]
 
Back
Top