crosstab criteria

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

Why do I see "the microsoft jet engine database does not
recognise 'criteria' as a valid field name or expression"

where 'criteria' is a reference to dates in a form used in
my crosstab query to limit the date?

e.g
Between [Forms]![EmployeeSalesDialogBox]![BeginningDate]
And [Forms]![EmployeeSalesDialogBox]![EndingDate]

any ideas?
 
Jim,

As opposed to other query types, crosstabs require that parameters are
explicitly declared. To do that, open th query in design view, go to menu
item Query > Parameters and enter the exact same expression, i.e.:
[Forms]![EmployeeSalesDialogBox]![BeginningDate]
in the first available line, specifying the right type (date/time in your
case), then repeat for the second one. This will solve your problem.

HTH,
Nikos
 
Thanks Nikos - that works a treat...
-----Original Message-----
Jim,

As opposed to other query types, crosstabs require that parameters are
explicitly declared. To do that, open th query in design view, go to menu
item Query > Parameters and enter the exact same expression, i.e.:
[Forms]![EmployeeSalesDialogBox]![BeginningDate]
in the first available line, specifying the right type (date/time in your
case), then repeat for the second one. This will solve your problem.

HTH,
Nikos

Why do I see "the microsoft jet engine database does not
recognise 'criteria' as a valid field name or expression"

where 'criteria' is a reference to dates in a form used in
my crosstab query to limit the date?

e.g
Between [Forms]![EmployeeSalesDialogBox]![BeginningDate]
And [Forms]![EmployeeSalesDialogBox]![EndingDate]

any ideas?
Click to expand...


.
Click to expand...
 
Back
Top