Highlighting data changed

[pharrison74]

I have a few reports that need to have the data highlighted that has been changed since the last entry. The data is put in by a form then the data is pulled and the report printed on a weekly basis.

I need to be able to highlight the data changed as well as the Case name so they can look at the table of contents and know right away which cases to concentrate on.

I know there is conditional formatting but I don't believe it has the ability to noticed what data has changed since last entry.



Thanks
PEter

[cyanidem]

Nope. I believe that to highlight any changes you would have to store previous versions of data as well and compare to actual ones when report is created.

[orange]

Not sure I'm following, but working with reports seems late in the process.

Tables store data. Forms are like windows --giving you a view to data in the underlying table.
It seems you are dealing with changes in data values. That is, data already stored, and new data to be stored. So, along the lines of what cyanidem said, you would seem to need some method of storing these different values. In fact, you may need to maintain multiple versions, if you need to show an historical progression of values. This seems very much like a version control system --much like developers may use to store (and recover) various versions of programs/procedures.

[cyanidem]

@orange
You're absolutely right, I made a shortcut here jumping straight to reports. Obviously old data need to be stored IN TABLES to later show changes.