Update query expression

[bluemat]

A simple one

I have two fields [Date1] and [Date2]

I want all the records in my database to have the follwing relation

I want that each Date2 record be 2 days more than its corresponding Date one record. Can you hepl me make the right update expression?

Thanks

 

[Isadore]

In your update query simply put as your "update" criteria for [Date2]:

[tblMyTable].[Date1] + 2

...that shd do it...