How do I insert a form (parameters) into a crosstab query?

M

mjps

I have created a form to limit output of data, but am unable to insert into a
crosstab query. I keep getting an error message saying that the database
does not recognize the string as a valid expression.
 
D

Duane Hookom

You need to enter the data types in the Query->Parameters. Something like:
Forms!frmDates!txtStartDate Date/Time
 
M

Marshall Barton

mjps said:
I have created a form to limit output of data, but am unable to insert into a
crosstab query. I keep getting an error message saying that the database
does not recognize the string as a valid expression.
Click to expand...


Crosstab queries require you to specify the parameters anf
their type in the query's property sheet.
 
M

mjps

Thank you! Saw one of the examples you posted in a previous response ...
you're extremely helpful!
 
Top