Results 1 to 2 of 2
  1. #1
    Kthorgesen
    Guest

    Elminiate multiple subjects in query

    (access2000)I have created a query of people who have had an appt. scheduled for my office. However, I am keeping track if they "NO SHOW" for the appt. Some people have multiple NO SHOWs. I want to produce a query with all people who have a NO SHOW, but if they have multiple NO SHOWs, I only want their name to appear once on the list. How can I do this?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Elminiate multiple subjects in query

    in query design click on view then totals
    then set the total section of the field to group by

Posting Permissions

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