D
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.
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.