Help with Append Query

[Cam]

Hello,

I am trying to create an append query to append only records that were
changed anytime when the query is ran.

Another way of saying is append only records where all the fields are not
the same. I have a table with say 10 different fields. Each day, the
operation, workcenter, etc. changes daily. Thanks

 

[Klatuu]

You will need an additional field in your table. It can be a Yes/No field.
In you form, use the form's After Update event to set the field to True.
Filter your report's recordset to include only rows where the field is true.
To reset the field after you run the report use the report's Close event to
run an update query that resets the field to False.