How to refer to the Month of a date field type to be used in a query

[behnam]

Hi all,

In my table i have two fields called resolved which is represented by a checkbox and one called date which is a date type (ie. 5/13/2014). First i wrote a query that returns a count of all the records that have resolved checked and placed it in a textbox with the following code.

Text16 = DCount("[Resolved?]", "Power Outages", "[Resolved?]=true")

how can i modify this code to not only check for which boxes are checked but also the month for the date has to be january.


Thank you

[RuralGuy]

Perhaps this link will help: http://access.mvps.org/access/general/gen0018.htm

[ranman256]

The 3rd section of DCOUNT is the where clause. Add MONTH to the query "Power Outages"

text16 = DCount("[Resolved?]", "Power Outages", "[Resolved?]=true and [month]=1")