Append Query Query!!

[Dowsey1977]

I am trying to do an append query which will add rows that aren't in 1 table to another. So I have all the fields in the table with the extra rows in it, and the table I want to append 2 has the Autonumber with 'Is Null' so it shos only the ones not in the destination table. I have a relationship where it shows all records from the source table.

Firstly, when I click to make it an append query, it auto-adds all of the 'append to' informatin except one field, which I add. Then when I try and run the query I get a message saying I have selected the null value on a field that is not a variable so won't let me run the query?!

Any ideas?

 

[Dowsey1977]

Just to let you all know, I've now fixed this!!