no not include table

[smiley0q0]

i am a novice with access... so this might be a dumb question...

i have 2 tables, one with 500 usernames (TblMain) and another with 20 of those user names (TblFilter).

i would like to make a query that lists all of the user names in the main table except for the ones that are in the filtered table.

any help will be appreciated..

thanks

 

[Eupher]

Sure, use the "Find Unmatched Query Wizard". From the database window, click Queries, then click the "New" button, then select "Find Unmatched Query Wizard." That should get you started.

Ken S.

 

[WayneRyan]

smiley0q0,

The syntax is:

Select *
From YourMainTable
Where YourKeyField Not In
(Select YourKeyfield
From YourOtherTable)

Wayne

 

[smiley0q0]

thanks guys.

'preciate the help.