![]() |
Parameters In External ODBC Data Queries - "is one of"
I want to qry an access table and display results in excel. parameters for
the criteria to be set in excel. I have followed the Nick Hodge write-up (http://www.nickhodge.co.uk/gui/datam...taexamples.htm) and that works fine so far. But: one of the criteria is a "In(list)". I want to receive all records where field A is one of (USA, Mexico, Canda) Question: what syntax must I use for the value list in the parameter field in Excel? (have tried separated by blanks, comma, comma+blank, enclose in singel quote, double quote - but no success so far. |
All times are GMT +1. The time now is 02:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com