PROBLEM COMPLEX for me!:-)

[sal21]

Into the access mdb have a table MASTER with field named INDICE and field named TEST.

Field INDICE contain a unique value(no duplicates are here).
Filed TEST contain blank values.

Into TABLE1 have the same field INDICE with unique value and filed TEST contain blank values.

I want to match from TABLE1 all value in INDICE with the filed INDICE of MASTER.

If one value of INDICE of TABLE1 is present in INDICE of MASTER insert in TEST of MASTER "FOUND".
If the value into TABLE1 not is present into MASTER INDICE insert into field TEST of TABLE1 "NOT FOUND"

I hope understand me:-(

[HansV]

Try this:

UPDATE TABLE1 LEFT JOIN MASTER ON TABLE1.INDICE = MASTER.INDICE SET TABLE1.TEST = IIf(IsNull([MASTER].[INDICE]),"Not Found","Found")

[sal21]

Try this:

UPDATE TABLE1 LEFT JOIN MASTER ON TABLE1.INDICE = MASTER.INDICE SET TABLE1.TEST = IIf(IsNull([MASTER].[INDICE]),"Not Found","Found")

gENIUS!