Update Query with Criteria

[cgemmill1]

I used to know this, but have forgotten it. I want to create an update query to change admissions to zero for the month of December. I am getting stuck in the criteria.

My table has the following CMSID, Admission, StartDate

I enter startdate =12/01/12 in the criteria and it will not work. I have tried brackets as well. What syntax am I missing?

 

[jzwp22]

How about this:

WHERE startdate BETWEEN #12/01/12# AND #12/31/12#

 

[cgemmill1]

Close but here is the actual syntax [MeasurementStartDate]="12/1/2012"

 

[jzwp22]

Is the measurement start date field set up with a text data type or a date/time data type?

If it is text, convert it in your criteria

WHERE cdate(measurementstartdate) BETWEEN #12/01/2012# AND #12/31/2012#