| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying Criteria in Excel Cell to MS Query Pull from Access | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Run Access query from Excel, input value to query being value in c | Excel Programming | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Using InputBox to change query criteria in Access | Excel Programming | |||
Threaded Mode
