Rick,
Thanks for the reply. I've tried everything I know to get it to show up and that makes sense. Adding a column in Excel with the course ID is what we've been doing but was hoping to cut out a step so others in the office will have less trouble with it. We also have to change out the - to 0 when someone doesn't do all of their homework so Access will accept it. I may try to add a user field that says Course ID and get it that way.
Thanks,
Mark