Change Date in Table with Update query

D

Diggsy

Hello,
I have a very large database with many Weekly Date entries. The problem is
that I would like to change every date in my DB to the previous day. For
instance I have a entry for the Week of 07-08-2007 and would like to change
that to 07-07-2007. I need to to this for all dates. The field is called
Week. Any help would be appreciated Thanks

Chris
 
K

KARL DEWEY

Create an update query to update the field 'Week' with this --
DateAdd("d",-1,[Week])
 
Top