Here is my problem.

I am trying to query a query held in Access 2003 from Microsoft Excel. I
have done this successfully using VBA. The problem is that I dont want the
access query to contain ALL the data so I need to use criteria ( Where
Clause ). This is ok except for the fact that the ODBC Driver returns an
error telling me it requires a number of parameters.

Any ideas on how to get around this