help please

[Access_help_rob]

Hey there, i just wondered is it possible to update a table with data that is not already there. Fo example say in my table i have number 1-10 and those numbers have notes by the side of them, now in my query i have number 1-20 but i dont want transfer all 20 accros i just want the ones i dont have in the table is that possible please help
rob

 

[namliam]

Try using an outer join... (unmatched in the wizard)

Regards

 

[Access_help_rob]

what do u mean by that?
please help
rob

 

[Mile-O]

what do u mean by that?

Do some detective work! Type Outer Join or Join Types into the help.

 

[Rich]

Use the Unmatched query wizard and then change the query to an append query