change month in date value from 9 to 10

[mtonkovich]

Dear NG -

Could someone help me figure out how to change the month value of a
date value from 9 to 10. IOW, I have about 20 records with dates like
09/20/2006 and 09/3/2006 and so on. All dates range from 09/01/2006 to
09/29/2006. I'm sure the dates were entered incorrectly and should
have actually been 10/01/2006, 10/29/2006 and so on. How might I do
this with an update query? I don't have any programming experience in
Acces. Thanks so much for all the help.

Mike

 

[Van T. Dinh]

Use an Update Query with the following SQL:

UPDATE [YourTable]
SET [DateField] = DateAdd("m", 1, [DateField])
WHERE ([DateField] BETWEEN #09/01/2006# AND #09/29/2006#)

I assume you don't have the non-zero time component in your date values.