Hi,
Im new to Access so apologise if this is a noobie question and Im just looking for a pointer in the right direction anyway.
I normally make websites but Im currently build a warehouse inspection reporting system in Access.
Got my Forms all setup, posting to tables and spitting out a nice report.
What I need it to do is wipe the tables clean each time for the new inspection bit keep the old data saved somewhere.
Basically the inspectors will obviously visit more than once client and as it stands at the moment, printing the report will print all they're reports off as one.
I was thinking they could just have a blank copy, copy it and rename the copy and use that each time but is there a way to automate this?
Thanks in advance.