Specifying criteria in Excel for Access Query

[Troubled User]

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

[Ron de Bruin]

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" <[email protected]> wrote in message news:[email protected]...
> 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
>
>