Hi. If I have a simple access table with three fields. these being:
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?