Query to update date column

[Christine via AccessMonster.com]

Hi,
I am trying to update about 4000 rows where 2 more days would need to be
added to the current dates. e.g.
1/1/2002 will need to be changed to 1/3/2002
5/1/2005 will need to be changed to 5/3/2005

All these rows have different dates and basicaly would like to add 2 more
days to them in an Access query and update the table.
I am new to this so your help will be very helpful.
Many thanks in advance.
Christine.

 

[fredg]

Hi,
I am trying to update about 4000 rows where 2 more days would need to be
added to the current dates. e.g.
1/1/2002 will need to be changed to 1/3/2002
5/1/2005 will need to be changed to 5/3/2005

All these rows have different dates and basicaly would like to add 2 more
days to them in an Access query and update the table.
I am new to this so your help will be very helpful.
Many thanks in advance.
Christine.

You can do it with an Update Query.
Back up your table first.

Update YourTable Set YourTable.[DateField] =
DateAdd("d",2,[DateField]);

Change YourTable and [DateField] to the actual table and field names.