Newbie Question: How to change dates in a table

[ecm1701]

Hi all,

It's my first post here as I just wandered onto this site while searching for some help with one problem I have. I'm not a hardcore coder, just somebody trying to finish a database.

Ok, I have a Payroll database for work. I created my tables, reports, data entry forms, switchboard, and queries in this database with no problem and everything works fine. Access 2000 is pretty forgiving to the newbies. Now, what I want to do is to make a procedure to go through a payroll table and add seven days to every date in the table. I can do "Edit->Replace" just fine, but I'm trying to make this databse idiot-proof for the others in my office who may need to use it. Any help in this matter would be greatly appreciated because I've completely hit a brick wall on this one. Thanks in advance.

[ecm1701]

...Bueller...Bueller...Bueller...

[brucevde]

Create an update query and execute it whenever you need to. Your query would be something like


UPDATE Payroll SET Payroll.DateField = DateAdd("d",7,Payroll.DateField);

[ecm1701]

You don't know how long I've been trying to figure this out! Thanks loads! I already set up the controls to add the Update query and it works like a charm! Again, thanks a lot for your help.