[Run-Time Paramters] and Crosstab Queries

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

Guest

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.
 
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.
 
Thank you Duane. That was very helpful.

Duane Hookom said:
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


Michael Reinhardt said:
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.
Click to expand...
Click to expand...
 
Back
Top