Append query based on existing info

[kilobyte]

Wow, seems like this is my favorite place in the world now.

My problem is that I need to append data from one table to another, on the condition that any of the fields in the record have changed since the last time the query ran.

For example,

tblEmployee has the fields 'EmployeeID', 'Name', 'Position', and 'Office'. We are appending to tblEmployeeHistory with the same fields in addition to a field for a date. When executed, the query should append the records where something has changed and attach today's date to them. This enables us to later use another query to call up old information based on the date.

Once again, this is a hypothetical situation and not my actual database. Any solution or comments are welcome.

 

[ScottGem]

Not the way I would do this. Instead I would enter data directly into the History table whenever a change was made with the effective date.

 

[kilobyte]

I am afraid that isn't possible. I don't have control of the original tables or forms. My database is kind of an extention of one that was professionally built. The original database is able to make a user viewable version of itself but I can't actually change the way it works. So, the idea is to have this query run whenever we refresh the user viewable database. That way, we can know the way things used to be as well as the way they are now.