Beginner Question - Update Query

[Paul Axelrod]

I have inherited an Access database, version is 2002 on a Windows 2000
machine.
One of the tables has approximately 14000 records, one of the fields
in the table is a date field in the mm/dd/yyyy format. I need to
update all the dates in the table by six months. Is there a way to do
this, using an update query? I cant seem to get it to work.

Thanks for any guidance.
Paul

 

[Van T. Dinh]

Yes. A Query with SQL String something like:

UPDATE YourTable
SET DateField = DateAdd("m", 6, DateField)

if you want to set the Date in each Record to 6 months later.

 

[Paul Axelrod]

Thanks for the tip, works like a charm.

Yes. A Query with SQL String something like:

UPDATE YourTable
SET DateField = DateAdd("m", 6, DateField)

if you want to set the Date in each Record to 6 months later.