I'm maintaining a table that contains all the people in our part of the company, about 700 rows. Human Resources will provide a spreadsheet weekly that contains the latest data. I have a work table that I clear, then import all the data from the spreadsheet.

The next process is to identify any new people. I want to find rows in the work table whose employee numbers do not exist in the main table. I'm looking for suggestions on how to implement this process.

Don,
Is your main table indexed, by employee number?

Kevin

dartcoach

Yes. The primary key is email address, but employee number is unique and indexed.

Don,

In the query wizard, there is one for "Find Unmatched Query Wizard".
This will build a query where based on a field in table #1 compared to a field in table #2 doesn't exist.

HTH,

Kevin

dartcoach

This doesn't appear in my Query Type dropdown list. I find Select, Crosstab, Make Table, Update, Append, and Delete.

I'm running Access 2003 in XP Pro.

Don,
When you create a new query, the first box that pops up is where that is. Not inside the query wizard. Sorry about that.

Kevin

dartcoach

Don,
Can you send me the names of your 2 tables, and the fields that you are trying to check against? I'll create the query sql for you and post it.

Kevin

dartcoach

I'm trying to get to the right place. I start the query wizard, select the People Load table, select the fields, select the People table, select the corresponding fields, click Next. I click on the box to modify the table, and now I see the design view. At this time, the Query Type icon becomes active: it was dimmed previously. I click the dropdown, and get the query types that I listed previously.

Don,
When you click new query, in the main screen, the first box that pops up has whether you want design view, or a wizard. One of the wizards is the one I mentioned above. It's before you ever get to design view.

Kevin

dartcoach

Hey, more than I expected.

Table: PeopleLoad fields: EmployeeNbr (Key), First, Last
Table: People fields: EmployeeNbr (Key)

I want to select rows in PeopleLoad that don't match on EmployeeNbr

Thanks for your patience
Don