ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Parameters In External ODBC Data Queries - "is one of" (https://www.excelbanter.com/excel-discussion-misc-queries/160437-parameters-external-odbc-data-queries-one.html)

Michael R

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