Question Locked

How do you save historical data for a text box in Access 2007?

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am creating a client database that needs to have historical data for changes in certain text boxes. I also need to do comparison reports of current data to historical data. Is this possible and if so, how do you do it?

4 replies

by msodb2007

You need to create a duplicate table for the Historical Data. Rename each column with: HD. Example HDname, HDaddress. Link the table with a subdatasheet. You can create a simple query, change the view and compare the data in a pivot.

This discussion is closed to new replies.