05-03-04, 17:43 #1Registered User
- Join Date
- Apr 2004
Unanswered: Running Crosstab from Report - Error
I have a Parameter/Crosstab query that runs perfectly on its own. When I attempt to run a report based on the query, I get the infamous error:
The Microsift Jet database engine does not recognize "mmm_test_cross" as a valid field name or expression."mmm_test_cross" is the query name.
The query has an expression that concatenates text from three fields, then converts the string into Date/Time. The param's apply to this field.
Last edited by beersnob; 05-05-04 at 15:26. Reason: oops