MS Query in Excel

[MikeDBMan]

If I am pulling data from an external, Access table, Excel uses MS Query and it does not appear I can include multiple WHERE items in my sql statement. Even if I edit the properties and change it to say this:

EnzymesMo.YYYYPP>='201102' AND EnzymesMo.Project ID='2121'

It gives me an error. Suggestions?

Is there another way to get the data?

 

[Gary McMaster]

A "Parameter Query" might be an option.

http://www.dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/

Gary