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.
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.Code:Text16 = DCount("[Resolved?]", "Power Outages", "[Resolved?]=true")
Thank you