Append query with criteria to coimpare values of 2 fields

  • Thread starter Thread starter Samuel
  • Start date Start date
S

Samuel

Hello,
First,Thanks for any help!
I have 2 tables with similar values sales_table and
old_sales_table. The values in the 'price' column of the
sales_table will vary often. I want to create an append
query that adds only those records in the old_sales_table
from the sales_table whose 'price' value has changed.

Any pointers arethankfully welcomed!
 
You'll probably need to link the tables by the productID and price fields.
An outer join may help to locate those that don't match, or just skip the
join and do it all in the WHERE clause.
 
Hi,
I tried using '
Where <>Old_sales_table.[Price]..BUt I get an error that
I am "not using the specific expression 'Price' in the
aggregate funtion."
Thanks for any further help!!!
Regards,
Sam
 
Back
Top