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

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

Guest

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.
 
You need to enter the data types in the Query->Parameters. Something like:
Forms!frmDates!txtStartDate Date/Time
 
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.
 
Thank you! Saw one of the examples you posted in a previous response ...
you're extremely helpful!
 
Back
Top