Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Complex Query
Why couldn't you use the general approach below Select Id, fk from table where fk = @Race1 AND Id In (Select ID from table where fk = @Race2) Id is the field for the racer, fk is the field for the race numbers, @Race1 and @Race2 are replaceble parameters. If you wanted to do an entire days...- KennethH
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
