Reporting Question?

[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

 

[Guest]

yes.
in a text box's control source put...
=sum([query1]![perticularfield])

 

[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