Query to update date column

  • Thread starter Christine via AccessMonster.com
  • 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.
 
R

Rick B

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
 
C

Christine via AccessMonster.com

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
 
R

Rick B

+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.
 
C

Christine via AccessMonster.com

Rick, many thanks. It works. Thanks for being patience.
Very nice.
 
Top