Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    London
    Posts
    341

    Cool Unanswered: Displaying specific values in a report

    My database contains a table "evaluations", certain questions have a corrsponding button "Excellent" "Good" "Adequate" & "Poor", the table records these as 1, 2, 3, 4, & 0 (0=No Response).

    What I need is to produce a report which shows everycell with values 1 to 4 but not those displaying 0.

    a typicall table might look like this

    Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10

    RECORD 1: 1 2 1 2 3 1 0 0 1 2
    RECORD 2: 3 4 3 0 0 1 1 2 3 0
    RECORD 3: 1 1 1 2 2 2 2 2 3 4

    So far all I have been able to produce is a report displaying Record 3 (the only record not to contain the "0" value).

    I would like a report which shows this:

    Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10

    EXP 1: 1 2 1 2 3 1 1 2 1 2
    EXP 2: 3 4 3 2 2 1 2 2 3 4
    EXP 3: 1 1 1 2 3

    Can anyone help?

    Regards

    Christyxo

  2. #2
    Join Date
    Oct 2003
    Location
    London
    Posts
    341
    ... Lost all the formating.

    Please see the attached for what I need.

    Regards

    Christyxo
    Attached Files Attached Files

Posting Permissions

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