On creating select and append query

G

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
 
M

[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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top