Crosstab query "Microsoft jet Database error"

[darkhat01]

I am trying to count the records that are in a query that I created. I am doing this with a Cross tab query.

If I put "Like [Forms]![Company_Reports]![txtPortfolio]" in the criteria to filter the query I created, it still works fine and does filters what I need, but the cross tab that I created returns an error: "The Microsoft Jet engine does not recognize 'Like [Forms]![Company_Reports]![txtPortfolio]' as a valid field name or expression.

How can I get around this error?

Thanks,

Darkhat

 

[PHV]

In the SQL view pane of your crosstab query add the following as the very first line:
PARAMETERS [Forms]![Company_Reports]![txtPortfolio] Text(255);

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[darkhat01]

That did the trick... Thanks PHV... That is another thing that I have to learn about.

Thanks,

Darkhat