Where Field 1 in Table A does not equal Field 1 in Query B

[talia679]

I didn't know a better way to word that subject for you all ... here's what I want.

I have Table A & Query B both contain a field entitled Username.

I want a query that only shows me Usernames that are present in Query B but not Table A.

Here's what I had.

Field: Username
Table: Query B
Total: Where
Sort:
Show:
Criteria: <>([query]..[Username])


This however asks me to Enter a Parameter Value.

I also tried this in Criteria:

Criteria: Not Like([query]..[Username])

Am I putting this in the wrong syntax or is it not possible to do this in the first place?

 

[raskew]

In your application's database window, click on Queries / New / Find Unmatched Query Wizard. Follow the instructions.

 

[talia679]

That is GREAT! ... I can't believe I never even noticed that before. I guess we don't always look for the obvious answers.

Thanks for the help. Did just what I wanted.