Query Criteria Based on a Cell in Excel

[smaumau]

Is there a way to make the criteria for a query pull from excel? I have an ODBC link in Excel from a query I have in Access. I would like to be able to change the dates the query uses without going into Access to change the query. Is this possible without an extensive knowledge of VBA?

 

[khawar]

You can either give reference to that value in the query in the criterea
or
you can use inner join to get only those records which match the value the query which is based on excel