update fields

[Candyk]

Hi, I have a table with 2006 model numbers and prices. I want to have Access
(2003) update the 2006 price field with the new 2007 prices by matching the
model numbers that are coming from a new table with 2007 prices.
Also, can Access tell me if there are any new model numbers in the 2007
table that were not in the 2006 table?
Any help would be greatly appreciated!
Thank you and regards,
Candice

 

[bazoorg]

Hi, I have a table with 2006 model numbers and prices. I want to have Access
(2003) update the 2006 price field with the new 2007 prices by matching the
model numbers that are coming from a new table with 2007 prices.

click on new query, goto design view
add the two tables
change the query type to update query
link the model number columns with an inner join
add the column up want to update (2006.price)
in the update to field type in [2007].[price]

that should work, not used access for a while tho...

Also, can Access tell me if there are any new model numbers in the 2007
table that were not in the 2006 table?

click on new query and use the 'Find Unmatched query wizard'