Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014

    Unanswered: Query gives error "Microsoft access doesn't recognize as valid field or expression"

    I have a cross tab query with parameters defined. Query runs fine. However when I run report it give me error "Microsoft access doesn't recognize as valid field or expression". So what's happening is I have 3 fields say A, B, C on the report . A is text fields others 2 are counts. If backend doesn't have data for say either field B or C then it gives me this error. Query is of full page I can post if somebody wants to see.

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    I don't do this sort of thing, as a rule, but I think this post addresses the problem you're having:

    Using Crosstab Queries in Reports

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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