G
Guest
I have 6 fields in a query. All fields come from one source table. If there
is a change to any of those 6 fields weather it be one filed or all 6 fields.
What type of expression can I put into the criteria to catch the change and
update it to another target table. I just need the expression part. I was
thinking under each field some like this..<>[productsTable].[productId] and
under description field..
...<>[productsTable].[Description]and so fourt. Would this work to capture
the changes then use an update query to move the data? Thanks in advance
is a change to any of those 6 fields weather it be one filed or all 6 fields.
What type of expression can I put into the criteria to catch the change and
update it to another target table. I just need the expression part. I was
thinking under each field some like this..<>[productsTable].[productId] and
under description field..
...<>[productsTable].[Description]and so fourt. Would this work to capture
the changes then use an update query to move the data? Thanks in advance