Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HELP!!! Filtering data (Access 97)

    I have a large database that keeps track of people attending our training sessions. I have a table of employees, course, and courses attended. I have created a query to pull all the data so I can see who has and has not attended class. I have generated a report that shows when a person is scheduled for class, the name of the class, location, date and whether of not they came to class. If they did not attend, I have it post NO in the margin of the report. As usual, I have people register and not attend many times so they may have 3 entries - two with NO and one with YES. I can filter the people who have never registered but now the CEO wants to know who have a NO only. How can I check to see if there are only "NO"s when a person could have several and then a YES.

    Please HELP as soon as possible!!!!!

    Thanks,
    Deborah

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: HELP!!! Filtering data (Access 97)

    If your attendance field is a Boolean (a Yes/No field), you can create a Totals query that groups by person, and sums the attendance field. In Access, False/No is 0, and Yes/True is -1. So if a person has only No's, the sum will be 0; if there is at least one Yes, the sum will be unequal to 0. Filter out the persons with only No's by setting a criterion of 0 on the sum.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HELP!!! Filtering data (Access 97)

    THANK YOU....THANK YOU......THANK YOU!!!!

Posting Permissions

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