Can parameter queries working with crosstab queries.

[Guest]

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

 

[Rick Brandt]

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.

 

[Guest]

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

Thanks,
FatMan

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.