Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use a form to enter report criteria from a crosstab query

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I would like to use a form to enter report criteria from a crosstab query. I can do it in a regular select query but how do you do that in a crosstab query?
 
It's done the same way.. unless you're trying to limit something that makes up the value columns. In that case you need to make a query to feed your crosstab and put the restriction in the feeding query. Joe Miller
joe.miller@flotech.net
 
I receive this error:
The Microsoft Jet Database engine does not recognize [Forms]![Goal]![cboGoal] as a valid field name or expression. But when i change it back to the select query it works fine.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top