On creating select and append query

[Guest]

Hello,
I need to create transfer some records from a 'sales' table to another
'details of change' table.
the transfer is to be made if there is a change in the 'discount' column of
the sales table.
the change can take place due to several reasons. I want the new 'details of
change' tableto reflect all the changed records.

how do i create a select query that chooses those records whose discount
fields have changed and how can i 'transfer' these record to an append query
and finaaly to my 'details of change' table.

Also, any new record in the 'sales' table also needs to be added to the
'details of change' table.

Thanks for ur inputs. I am new to access.so plz pen ur responses accordingly.

thanks

 

[[MVP] S.Clark]

First you would have to somehow record that the discount was changed. A
changed date, or a checkbox will do. Then query for those records(based on
the logical criteria). You can't transfer records per se, but you can
append them using an Append query. If you need to complete the transfer,
you can execute a Delete query to remove them from the original source.