If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Query Questions
Hi,
I have a table called AHRQ with a date/time field called DISCHARGEDATE and a numeric field that is currently blank called DISCHARGEYEAR. The DISCHARGEDATE field has normal date values (i.e. 6/1/2008). I want to run an update query that will populate the DISCHARGEYEAR field with the value 2008 if the discharge date is a 2008 date. I keep getting an "Data Type mismatch in criteria expression" error when I run the following query. I have changed the format of the DISCHARGEYEAR field from text to numeric but get the same error. Can someone help? Thanks, UPDATE AHRQ SET AHRQ.[DISCHARGEYEAR] = "2008" WHERE (([DISCHARGEDATE] Between "1/1/2008" And "12/31/2008")); |
Thread Tools | |
Display Modes | |
|
|