spreadsheet values as query criteria

[antonyx]

i have a column of reference numbers in an excel spreadsheet and i want to use them as the records in a report.

i can set up the query using the fields i want (and the report) but how can i set the query to use the spreadsheet values?

 

[antonyx]

for the moment i have just pasted the excel values into a separate table and made a query from that..

it appears my first request is no longer needed.