Saving a table and comparing it to future changes

[JuniorWoodchuck24]

Not sure if this method is going to work for the task I'm trying to accomplish so was going to get some input from the experts. Currently I have a table with all my information stored in it (tblOverall). Everytime the information has reached a certain level of completeness it is issued. When I issue the information I allow the user to go to a form and click a button that then runs an append query that places tblOverall into tblOverallRevA. The next time tblOverall is rev'd up it will be appended to tblOverallRevB. With this in mind I have a report that I want to design to allow the user to compare the current tblOverall to older revs. I do this by having two subreports. One subreport brings in the current tblOverall and the other one pulls in the tblOverallRevX (X being A/B/C/etc) based on code. All of this works fine, but the next item I can't get to work. I want the report to flag items that have been changed during a rev so the user can easily view the changes that were made. So for instance if I was developing a training database and the user first had a bench of 225 lbs, and then the next time he had 235 lbs, it would flag that field and leave the items that stayed the same alone.

Any help is much appreciated. Thanks.

 

[ghudson]

You could add a Yes/No field for each field and do a comparision of each field and if different then mark that fields Yes/No with a Yes and show that in your comparison report. If you have a lot of fields then that is a lot of work.