Adding Parameter to query linked to a cross tab query

[ps32208]

Hi,

I have a select query which is created from a crosstab query. I want to add a parameter to the query but the usual [Enter xyz...] method in the criteria row of the query doesn't work, returning the following error msg: The Microsoft Jet database engine does not recognise '[Enter XYZ]' as a valid field name or expression.

How can I fix this?

 

[JerryKlmns]

How about posting the SELECT sql statement and say which field (and what data type is) of the crosstab query you need to filter?

 

[danvlas]

You need to declare the parameters using Query-Parameters to use them with cross-tab.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html