Tblqryfrmrpt
New member
- Local time
- Today, 15:59
- Joined
- May 10, 2011
- Messages
- 6
Hi everyone,
I'm trying to create a "Change Log" type of table based on my append and update queries. I have two tables, tblHistorical and tblDaily (data dump). They have the same exact headers. Each day, I have an append and an update query that will append/update the information in tblHistorical from tblDaily.
My problem is how to use a query to build/update another table (tblChangeLog) that will list the pk, a few other identification fields for readability, the field that was updated, old value and new value and finally update date. If nothing has changed for that record, it should not be listed in that table. I've looked at a lot of examples online and I can't find anything that is similar to my issue. The only examples I see are audit trails for when a user changes information in a table using events.
Any ideas?
Thanks
I'm trying to create a "Change Log" type of table based on my append and update queries. I have two tables, tblHistorical and tblDaily (data dump). They have the same exact headers. Each day, I have an append and an update query that will append/update the information in tblHistorical from tblDaily.
My problem is how to use a query to build/update another table (tblChangeLog) that will list the pk, a few other identification fields for readability, the field that was updated, old value and new value and finally update date. If nothing has changed for that record, it should not be listed in that table. I've looked at a lot of examples online and I can't find anything that is similar to my issue. The only examples I see are audit trails for when a user changes information in a table using events.
Any ideas?
Thanks