Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I have a crosstab query to count the value (Agree, Disagree, NoResponse) in "Responds" field. Then I have a report based on the crosstab query, which have three text boxes for Agree, Disagree and NoResponse.

    Based on the date range I input to generate the report, some time there's no data at all for NoResponse. Then after I generate the report, I will get the error message: "The Microsoft Jet database engine does not recognize 'NoResponse' as a valid field name or expression."

    Any suggestion how to resolve this error?

    Thanks in advance.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Have a look at this thread just down the page a little.
    Regards
    John



  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by John Hutchison View Post
    Have a look at this thread just down the page a little.
    Thanks, this works.

Posting Permissions

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