Newbie Question: How to change dates in a table
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.
Anybody have a clue at all?
...Bueller...Bueller...Bueller...