Reporting Question?

  • Thread starter Thread starter Paul Murphy via AccessMonster.com
  • Start date Start date
P

Paul Murphy via AccessMonster.com

Hi folks,

Tell me this.... in MS Access Reports, can you use the 'SUM' command to
produce the total of partiular fields?

Thanks,
Paul
 
You most often would not include the "[query]!". Just use a text box in a
report or group header or footer with a control source like:
=Sum([NumericField])

--
Duane Hookom
MS Access MVP
--

yes.
in a text box's control source put...
=sum([query1]![perticularfield])
-----Original Message-----
Hi folks,

Tell me this.... in MS Access Reports, can you use the 'SUM' command to
produce the total of partiular fields?

Thanks,
Paul
Click to expand...
Click to expand...
 
Back
Top