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

  • Thread starter Thread starter RockNRoll
  • Start date Start date
R

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
 
Hi Dave

This should work for you:

DSum( "FieldToBeSummed", "TableName",
"DateField between #1/1/2004# and #1/31/2004#" )
 
RockNRoll said:
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.
Click to expand...


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