Query to compare new data based on known user ID

[googoodoll2009]

I have a data table that contains student information which new data is added
to frequently.

Unfortunately the new data that is added doesn’t always contain correct
spelling of the student’s names which creates many duplicate entries.

There is a Student ID that is assigned to each student that I would some how
like to bas a query on that I can match the new incoming data that is brought
into a datasheet form from an Excel spreadsheet to make sure that the student
names are correctly spelled.

Is there a way to do this with a query by checking against a table that
contains only the student ID and names?

Thank you in advance.

googoodoll2009

 

[John W. Vinson]

I have a data table that contains student information which new data is added
to frequently.

Unfortunately the new data that is added doesn’t always contain correct
spelling of the student’s names which creates many duplicate entries.

There is a Student ID that is assigned to each student that I would some how
like to bas a query on that I can match the new incoming data that is brought
into a datasheet form from an Excel spreadsheet to make sure that the student
names are correctly spelled.

Is there a way to do this with a query by checking against a table that
contains only the student ID and names?

Thank you in advance.

googoodoll2009

Of course. Create a Query joining the (linked or imported) spreadsheet to the
student table by ID. You can use a criterion

<> [Students].[namefield]

on the name field (or fields) in the linked/imported table to find the
mismatches. DON'T trust the ID by itself - at least see if the "Bob Jones" in
the import has the ID of "Robert Jones", rather than that of "Alicia
Figueroa".