Can parameter queries working with crosstab queries.

I have a query that gets its criteria from a form. This query is complicated
in the fact that it draws part of its information from a crosstab query.
Because I am using a parameter query when I run the query I get the following
error message:

“The Microsoft Jet database engine does not recognize
‘Forms![frmIntakeStorageLocationReport]![comStorageLocationIDFrom]’ as a
valid field name or expression.�

Can anyone tell me if it is possible to use a parameter query in conjunction
with a crosstab query? If so how?

Thanks,
FatMan

"FatMan" wrote in message
...
I have a query that gets its criteria from a form. This query is
complicated
in the fact that it draws part of its information from a crosstab query.
Because I am using a parameter query when I run the query I get the
following
error message:

"The Microsoft Jet database engine does not recognize
'Forms![frmIntakeStorageLocationReport]![comStorageLocationIDFrom]' as a
valid field name or expression."

Can anyone tell me if it is possible to use a parameter query in
conjunction
with a crosstab query? If so how?

Go into the query in design view, right click in the upper portion on a
blank area and select "parameters" from the shortcut menu.

In most queries Access will resolve parameters automatically. With
Crosstabs Access insists that you explicitly enter them and provide the
appropriate datatype. You not only need to do this for Crosstab queries,
but also for any other queries that you use as inputs to a Crosstab query.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Rick:
You da man! Thanks - it worked like a charm.

Thanks,
FatMan

"Rick Brandt" wrote:

"FatMan" wrote in message
...
I have a query that gets its criteria from a form. This query is
complicated
in the fact that it draws part of its information from a crosstab query.
Because I am using a parameter query when I run the query I get the
following
error message:

"The Microsoft Jet database engine does not recognize
'Forms![frmIntakeStorageLocationReport]![comStorageLocationIDFrom]' as a
valid field name or expression."

Can anyone tell me if it is possible to use a parameter query in
conjunction
with a crosstab query? If so how?

Go into the query in design view, right click in the upper portion on a
blank area and select "parameters" from the shortcut menu.

In most queries Access will resolve parameters automatically. With
Crosstabs Access insists that you explicitly enter them and provide the
appropriate datatype. You not only need to do this for Crosstab queries,
but also for any other queries that you use as inputs to a Crosstab query.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com