Parameter Query Error

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

Guest

I have in the past based queries on fields in forms for example I would have as a criteria for a query as Between [Forms]![Calendar]![StartDate] and [Forms]![Calendar]![EndDate]. This works great for select queries. When I try the same in a crosstab which is based on the selct query I get the following error The microsoft Jet Databse does not reconize Forms!Calendar!StartDate as a valid FieldName. Why do I ge tthis error and how can I get around it.

George Schneider
 
George Schneider said:
I have in the past based queries on fields in forms for example I would have as a
Click to expand...
criteria for a query as Between [Forms]![Calendar]![StartDate] and
[Forms]![Calendar]![EndDate]. This works great for select queries. When I try the
same in a crosstab which is based on the selct query I get the following error The
microsoft Jet Databse does not reconize Forms!Calendar!StartDate as a valid
FieldName. Why do I ge tthis error and how can I get around it.Hi George,

Crosstabs require that you explicitly
set the parameter types.

In query designer, in top menu choose
Query / Parameters
and type in your 2 parameters and select type
in the dialog box.

I believe that will solve your problem.

Good luck,

Gary Walter
 
Back
Top