Comparing fields in a table.

[Wren]

I have a table where we track student’s scores.

The fields I am working with are,

Student Name (first and last)
Student ID
Test Title
Activity date
Score

The data we receive to populate the Student name field is often incorrect. I
can contain misspellings, nicknames first, middle and last names.

How can I create a query to compare each students name and update it if it
is not correct?

Thank you,

Wren

 

[Jerry Whittle]

The Student information, such as the Student Name, should be in a table
called something like Students. You make sure that the data is correct in
that table and don't use any other name sources.

Then you link the Student table to Test table using the Student ID field.