Comparison

[AMDGUY [MCP]]

I have 2 tables. Data Table and a Names table Both tables have a names field
Names are formated as LastName, Firstame

I want to create a query that shows me any field that or not equal.
Can some one show me an expression that will do this?

 

[Guest]

Go to the query section of the database window and use the "Unmatched Query
Wizard"

 

[AMDGUY [MCP]]

I do not see that wizard

Go to the query section of the database window and use the "Unmatched Query
Wizard"

:

 

[Guest]

Click on "Queries" then click on "New"...a new set of choices should become
available.

 

[AMDGUY [MCP]]

Thanks that greatly helped.

Do you know anything about visual basic filtering for querys.