Query to update date column

  • Thread starter Thread starter Christine via AccessMonster.com
  • Start date Start date
C

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.
 
What is your date field?
MAKE A BACKUP OF YOUR TABLE FIRST....


Make your query into an update query. Then in the "UPDATE TO:" field under
your date put....

=[YourDateFieldName] +2
 
Thanks, I did that and it deleted all the rows and evrything is all blank. I
did on a backup table.
Any idea.
Also by adding +2, how would it know to update only the day part of the date.
Thanks
 
+2 adds 2 days.

I don't understand how an update query could wipe out the data. Post the
SQL from your update query here so we can look at it.
 
Rick, many thanks. It works. Thanks for being patience.
Very nice.
 
Back
Top