Cross Tab Query Criteria

  • Thread starter Thread starter Robert W
  • Start date Start date
R

Robert W

I am attempting to pass the data in the following field to
a column heading criteria


[Forms]![frmFacilitiesByVendorBySelectedWells]![Text43]


I get an error message that say the Microsoft Jet Engine
does not recognize [Forms]!
[frmFacilitiesByVendorBySelectedWells]![Text43]as a valid
field name or expression

Have even tried the Eval([Forms]!
[frmFacilitiesByVendorBySelectedWells]![Text43]) function
and that too errors out.

Any thoughts would be greatly appreciated.

Robert W.
 
You must specify the query parameters in crosstabs. Select Query|Parameters
and enter
[Forms]![frmFacilitiesByVendorBySelectedWells]![Text43] Text (or
whatever)

BTW: do youself (and others) a favor by giving Text43 a meaningful name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Crosstab criteria 4
Cross tab query 9
Crosstab Query with Criteria 2
Want a Parameter for date range driving a cross tab query 2
Query Parameter Syntax 2
Parameterizing in a Cross Tab Query 2
Cross Tab Query 3

Back
Top