Reporting Question?

  • Thread starter Paul Murphy via AccessMonster.com
  • 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
 
D

Duane Hookom

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...
 
Top