View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Specifying criteria in Excel for Access Query

Hi Troubled User

I add a new page to my site today
See the second example workbook in the zip file
http://www.rondebruin.nl/accessexcel.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Troubled User" wrote in message ...
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