Sum

[Pietro]

Hi,
What's the code that i should put in the controlsource of an unbound
control to do this:

Sum the field Calls of the query CMSdaily where datec between [forms]![cms
report]![from] and [forms]![cms report]![to]

Regard

 

[Rob Parker]

Hi Pietro,

A dSum is the most obvious. The expression in the control will be:
=dSum("Calls","CMSdaily","datec between #" & [forms]![cms report]![from] &
"# and #" & [forms]![cms report]![to] & "#")

Note the use of the # character as the delimiter for the date/time fields.

HTH,

Rob