JuniorWoodchuck24
Registered User.
- Local time
- Today, 01:56
- Joined
- Jan 13, 2010
- Messages
- 59
I'm having difficulties deciding on how to go about saving past information, but I believe an append query is the route to go. What I'm trying to do is once a project's information has been issued then the append query takes those line items from tbl1 and dumps them in tblRevA. So only the projects that have been rev'd up will be appended to the table. Now when tbl1 has info going from RevA to RevB it takes the info from tbl1 and appends the B status info to tblRevB. Was curious if there was a way to code criteria for a Rev Field in the Append Query to look at the Rev column and dump data based on the Rev it is.
Note: tbl1 will always have the most up to date information. the other Rev tables are for comparison so a report can be generated to show the changes made by comparing the different rev's
Note: tbl1 will always have the most up to date information. the other Rev tables are for comparison so a report can be generated to show the changes made by comparing the different rev's