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
 
You must log in or register to reply here.

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

Similar Threads

Append queries - Column Headers 2
Append Query Issue 0
Pull a field from a form to be the criteria of an append query 0
Append Rows based on field value 2
Criteria in append querie 3
Data changes in append query 1
append queries records with multivalue fields 2
Append query - Append to table with Autonumber field 2

Back
Top