Question

Locked

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

By dkitchens ·
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?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Historical Data

by MSODB2007 In reply to How do you save historica ...

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.

Collapse -

Reponse To Answer

by dkitchens In reply to Historical Data

Thank you.

Collapse -

Subdatasheet?

by MSODB2007 In reply to How do you save historica ...

Did this work for you?

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums