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