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?
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?