View Single Post
  #1  
Old September 10th, 2005, 01:50 PM
Lucky Louie
external usenet poster
 
Posts: n/a
Default "Find Unmatched Query" help for Football pool

Quick background...2 tables. 1 with all user information including Week1,
week2, week3 etc. (up to week 17). Every week, i have to enter a value into
that specific week #, but I cannot use the same team twice throughout the 17
week period. The teams come from another table, using a dropdown list (there
are 32 teams in table 2).
I am trying to get a query that only shows the teams (from table 2) that I
haven't already used.
Any help is greatly appreciated. (go dolphins!)