Results 1 to 6 of 6

If?

  1. #1
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Apr 2014
    Posts
    410

    If?


    Not sure how to get the results where I want to see all Clubs with a title President as well as if the club doesn't have a President.

    issue I am having now is that I get all other titles when I say don't show Club members that aren't Presidents.

    need to see records that have president AND records without BUT not the other titles.

    hope that makes sense.

  2. #2
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065
    Not enough information to give an intelligent answer so I'll give a dumb one.

    Assuming there are multiple clubs with multiple members and some member have a title and some don't the following Where should do it.

    Where Title = "President" or Title is null

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What is data structure? You have a field called Title? Is there a table/subtable relationship of Clubs and Officers?

    Maybe:

    SELECT Clubs.*, Officers.* FROM Clubs LEFT JOIN Officers ON Clubs.ID=Officers.ClubID WHERE Title="President" OR Title Is Null;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Apr 2014
    Posts
    410
    Try again.

    There are more than 1 club.
    Each club could have multiple Titles or "Roles" in the club. The club may not have a President however.

    I want to see all the clubs where there are Presidents and ones without.

    There are multiple tables
    1. Clubs (AKA: "Organizations")
    2. OfficerType (AKA: "Title" or "Role")
    and so on.

    Say there are 2 roles in an organization (Club 1) and one of them is a President and the other Secretary.
    But Club 2 has no President but has Secretary and Treasurer.

    I want to see both Club 1 and Club 2 info where Club 1 also shows the President info and Club 2 will be just the club info.

    Hope this makes more sense

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    So what is the structure of Clubs table? Is there a field for each officer?

    Try the WHERE CONDITION shown in earlier post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Apr 2014
    Posts
    410
    I think I got it figured out.
    I was trying to edit an existing View and decided to redo it it and think getting the results sought.

    thank you

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums