access query question

Hi. If I have a simple access table with three fields. these being:
New date
Old date
Frequency.

And I want to update the fields so the new date becomes the old date then the new date gets updated bu adding the frequency to the date and this is stored in the New date field.
How would this be done?
I can make a update query that will update the new date with the new date+ frequency and I can make a similar query with Old date = New Date. but how do I do this in one operation?
LVL 1
PawloAAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
update tableName
set [New Date]=[Old date] + [Frequency]

or

update tableName
set [New Date]=DateAdd("d" , [Frequency], [Old date])
0
 
peter57rCommented:
Update table set OldDate = NewDate, NewDate = NewDate + Frequency
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.