Results 1 to 2 of 2
  1. #1
    system32 is offline Novice
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    1

    How do I show a list of users who are not on a team in MS Access?

    I am currently using MS Access 2007 and am having trouble showing some data. I have a database corresponding to a hockey team. I have two tables which show coach information and team information. How can I make it so I create a query showing a list of coach's who are not assigned to a team?

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Not clear on your structure, but play with the unmatched query wizard, with the table/query of all coach's on one side and a table/query of assigned coach's on the other.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Don't show lookup list options in report
    By dara in forum Reports
    Replies: 1
    Last Post: 02-17-2010, 10:26 PM
  2. A team competition report
    By JOSE LUIS in forum Reports
    Replies: 0
    Last Post: 02-04-2010, 05:14 PM
  3. Access Locking other users out
    By David in forum Access
    Replies: 1
    Last Post: 07-02-2009, 09:26 PM
  4. Replies: 5
    Last Post: 05-02-2006, 11:25 AM
  5. Lookup or list field: how Do I not show all records
    By scott munkirs in forum Forms
    Replies: 4
    Last Post: 04-13-2006, 12:44 PM

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