Aloha! First post here. I have a little bit of Access knowledge gained from working with it for some time, but I need help with a new project.
I am the registrar for a car show. I gather entrants data (first name, last name, car make, model, year, etc.) in an Excel spreadsheet, and use Access to generate reports to help run the show. I would like to add a new report which will require input from a second Excel spreadsheet and I have no idea how to do this.
The first spreadsheet has the Car Number plus the details about the car (owner name, make, model, year, etc). The second spreadsheet has the winner for each class and has just two columns: Class Name and Car Number. The report I want to generate will list the winner for each class and also provide the owner and car information. Something like this:
Best Engine - John Doe, 1969 Boss 429, Blue with white interior
But, I have no idea how to do this. Any assistance would be greatly appreciated.
Harry Z