We've got a list of items in an excel sheet. Those items are the same as some in a field of out access database. Is there a way to write a query so that it only shows the items that match between the two?
Create a new table by linking to the worksheet in the Excel file. Then create a select query with an inner join between the field(s) in the newly linked table and the field(s) in the table that you already had in Access. This will return the matched records.