[Run-Time Paramters] and Crosstab Queries

[Michael Reinhardt]

I have a crosstab query that I want to use a run-time parameter (i.e. [Please
enter date]) in one of the fields that happens to be a Row Heading. When I
run the query, I get an error stating that the database does not recognize
'[Please enter date]' as a valid field name or expression. Is it possible to
use run-time parameters in a crosstab query, or can they only be used in
select queries?

Thanks very much.

 

[Duane Hookom]

You must enter the parameter data types for crosstabs: Query->Parameters:
[Please enter date] Date/Time

You should consider using a control on a form rather than a parameter
prompt.

 

[Michael Reinhardt]

Thank you Duane. That was very helpful.

You must enter the parameter data types for crosstabs: Query->Parameters:
[Please enter date] Date/Time

You should consider using a control on a form rather than a parameter
prompt.

--
Duane Hookom
MS Access MVP

I have a crosstab query that I want to use a run-time parameter (i.e.
[Please
enter date]) in one of the fields that happens to be a Row Heading. When
I
run the query, I get an error stating that the database does not recognize
'[Please enter date]' as a valid field name or expression. Is it possible
to
use run-time parameters in a crosstab query, or can they only be used in
select queries?

Thanks very much.