View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael R Michael R is offline
external usenet poster
 
Posts: 40
Default 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.