Results 1 to 2 of 2

Thread: Report display

  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Orlando, FL
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report display

    I am creating a report that displays student and the classes he/she attended or missed. I have a field that is a Yes/No field and on the report I have a section for each student and then a sub-section for the classes they attended or misses. In the attended header I want to display the words "Attended Classes" or "Missed Classes" depending on the Yes/No field. I have tried to create a text box with an If statement but am having no luck. Any help would be apreciated. Thank you.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report display

    =IIf([fldyesno]=-1,"Attended Classes","Missed Classes")

Posting Permissions

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