Results 1 to 1 of 1
  1. #1
    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.

    Any advice?

    Last edited by beersnob; 05-05-04 at 14:26. Reason: oops

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts