query to find any of 322 serial numbers in excel column in access db

[weeblebiker]

Hi,
I've been asked to find repair history in my access DB for any unit made in the past 10 years with a specific output range from an excel sheet and see if they have come back for repair in my access db.

I have linked the excel sheet to acces and have a query to generate a list of serial numbers that fall within the output and date ranges.

all repairs have the serial number listed in the table. a serial number can be in for repair more than once so is not the key.

what query do I do to return a result if the serial number in the output range query matches a serial number in the repair table? I suspect this is easy, but don't know how to frame it in access.

it's been 2 years since I did anything with this db, I'm quite rusty but quick to get back up to speed.
Thanks!!!!

 

[pbaldy]

I would expect a query that included both your query of serial numbers and the repairs table with a join on the serial number.