Getting a Total by Month and Year

[Paul Fenton]

Is there a way to use the DSUM function to get a total based on a
specific month and year? Say I want to see total sales for January of
2004 in a table that has a "Sold" field (currency) and a "DateSold"
date field for each record.

If not DSUM, then how would I do this?


Paul Fenton
(e-mail address removed)

 

[Ken Snell [MVP]]

This is a hardcoded way to do what you seek as a DSum function:

DSum("FieldBeingTotaled", "NameOfTable", "MonthField=1 And YearField=2004")

 

[Ken Snell [MVP]]

Or, using a single date field:

DSum("FieldBeingTotaled", "NameOfTable", "Month([DateField])=1 And
Year([DateField])=2004")

 

[Van T. Dinh]

Try something like:

DSum("Sold", "YourTable",
"([DateSold] >= #01/01/2004#) AND ([DateSold] < #02/01/2004#)")

(type as one line.)

 

[Paul Fenton]

Ken and Van, thank you very much, it works perfectly.


Paul Fenton