Using DSum to sum all Awards between 1/1/2004 and 1/31/2004

[RockNRoll]

Greetings,

I have a field on a report that I would like to be the sum of all awards
between 1/1/2004 and 1/31/2004. I believe DSUM is the correct function and
I have read up on the use of it, but am stumped on this one.

Thanks for your help,
-Dave

 

[Graham Mandeno]

Hi Dave

This should work for you:

DSum( "FieldToBeSummed", "TableName",
"DateField between #1/1/2004# and #1/31/2004#" )

 

[Marshall Barton]

I have a field on a report that I would like to be the sum of all awards
between 1/1/2004 and 1/31/2004. I believe DSUM is the correct function and
I have read up on the use of it, but am stumped on this one.

DSum("fieldto sum", "thetable", "awarddatefield Between
#1/1/2004# And #1/31/2004#)