Can parameter queries working with crosstab queries.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
FatMan said:
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?
Click to expand...

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.
 
Rick:
You da man! Thanks - it worked like a charm.

Thanks,
FatMan

Rick Brandt said:
FatMan said:
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?
Click to expand...

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.
Click to expand...
 
Back
Top