sql - append query, skipping duplicate entries (duplicates are not primary key) -

i have append query here. update existing projects table in access excel spreadsheet. ignore duplicates. each time run it, pops error final "projects.[measure]". did go wrong?

insert projects ([measure],[customer number], store, [customer name], [customeraddress], [measure received])  select [measure], [customer number], [store], [customer name], [customeraddress], [measurereceived]  newprojects  not exists ( select * newprojects newprojects.[measure] = projects.[measure] ) ; 

your main query includes subquery:

select * newprojects newprojects.[measure] = projects.[measure] 

that where clause references projects.[measure]. projects not included in from clause, access guesses projects.[measure] must name of parameter.

consider different approach. first create select query returns "non-duplicate" rows. left join newprojects projects , ask rows right side measure values null --- newprojects rows not present (not matched) in projects:

select     n.measure,     n.[customer number],     n.store,     n.[customer name],     n.customeraddress,     n.measurereceived     newprojects n     left join projects p     n.measure = p.measure p.measure null; 

investigate access "unmatched query wizard". can guide through process of creating similar query. whether use wizard or copy sample query , paste sql view, confirm returns correct (non-duplicate) rows. need add insert piece start of query:

insert projects ([measure],[customer number], store, [customer name], [customeraddress], [measure received])