Select vs. Crosstab Query

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

Guest

I have made a select query that refers to a control on a form i.e. [Forms]![Form Name]![Control Name]. This query works fine. When I make the exact same reference in a crosstab query I get an error message saying: The Microsoft Jet database engine does not recognize my reference as a valid name or expression. What is the difference between the two types of queries in recognizing names?
 
Steve,

Unlike other query types, in a crosstab you are required to explicitly
declare parameters. To do so, open the query in design view and go to menu
item Query > Parameters, and define as a parameter the form control
reference you are using in your criterion (type in the exacct same reference
and choose the right type). This will solve your problem.

HTH,
Nikos

Steve said:
I have made a select query that refers to a control on a form i.e.
Click to expand...
[Forms]![Form Name]![Control Name]. This query works fine. When I make the
exact same reference in a crosstab query I get an error message saying: The
Microsoft Jet database engine does not recognize my reference as a valid
name or expression. What is the difference between the two types of queries
in recognizing names?
 
Back
Top