View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Troubled User Troubled User is offline
external usenet poster
 
Posts: 85
Default Specifying criteria in Excel for Access Query

Assume I have a table in Access that has two fields: ID and Name. In Excel I
have a Drop List containing all of the Name(s) used in Field Name. Assume I
store the result of the selected Name from the Drop list in field Input!A1.
What I need to do is pass the value in Input!A1 into the query as a variable
constraint. I don't know the syntax for doing this. Please help.

WB