IIF sentence

[kharder]

Now lets see some magic...

I have to tables, where if data in one field is in both tables I don't want the row to be shown in my query.
I have triede with a IIf sentence, but I can't get it to work.

Any ideas??

 

[neileg]

Try using the unmatched records query wizard.

 

[kharder]

I solved the problem almoste after I posted my question in the moste simpel way. I don't know why I always have to try to do things more complicated than they are.

I took both fields and added them to the same query and tada the problem was solved.

By the way.. Thank you for the fast reply Neil.