Unmatched Query Question

[DoveArrow]

I have a database that I'm using to pull the names of students who
have applied for graduation from an Excel spreadsheet, that is updated
weekly, into an Access Table. Right now, I'm using an unmatched query
to pull Student IDs who have not previously appeared on the Excel
spreadsheet. At first, I was a little worried about this because if a
student applies for graduation with a dual degree, their name shows up
on the Excel Spreadsheet twice (see example below).

111000 Pig Porky BA.PSY
111000 Pig Porky BFA.FP

Fortunately, as long as the student's ID number isn't on the Eval
Status Database Table, both rows get pulled from the Excel
Spreadsheet, regardless of whether they match or not. However, what
I've discovered is that if a student applies for graduation as a
Psychology major, but then later changes their major to Musical
Therapy, my database won't pull the student from the Excel spreadheet,
because their ID is already in the Eval Status Database Table.

So my question is, is there a way to update the old major in the
database table with the new major from the spreadsheet using an
unmatched query, or some other method? If you need any other
information let me know. Thanks.

 

[Guest]

I think better than using an unmatched query to pull is to have a compund
index consisting of student ID and their major. Set the index to Unique.
This still will not help with a change in major unless the Excel has a flag
that it is a change and list the old one.