Beginner Question - Update Query

  • Thread starter Thread starter Paul Axelrod
  • Start date Start date
P

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
 
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.
 
Thanks for the tip, works like a charm.


Van T. Dinh said:
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.
Click to expand...
 
Back
Top