Need Help w/Crosstab Query

[J. Moats]

Hi and thanks for your help in advance.

I've created several crosstab queries that are used for creating graphs. I
need to query by form to set the query criteria parameters but I receive an
error message when I do this. I want to pull the data directly from the
table. The only way around this that I've found is to create a temporary
table with only the data in it that I need. If possible I would like to use
LIKE in the criteria - something similar to this: LIKE
Forms![frmGraph]![txtText10].

However when I query by form, using LIKE Forms![frmGraph]![txtText10], I
receive an error. The error states that Microsoft Jet does not recognize it
as a valid expression. How can I get around this without creating a
temporary table or get the query by form to work for a crosstab query?

Thanks,

Jim

[Michel Walsh]

Hi,

A crosstab query must have its parameter defined in respect to their data
type.

Hoping it may help,
Vanderghast, Access MVP

"J. Moats" <james....@intel.com> wrote in message
news:8pjrr2$5...@news.or.intel.com...