Search results

Well i got it to give me two different lists using two different queries... the two list boxes were each pointing to a different query (though the two queries contained the same data - the names and teams they are on) So when i would open the report, It would first ask me "Team Number 1:"...

sorry... I'm not really following you with the 3rd query idea (please forgive me, I'm learning :) )

Ok this seems to be getting way too complicated for me... I figured out a way to get the two lists by typing in the two team names... Make a query for Team 1, and another query for Team 2 (both listing the players names Then put a two list boxes in a report, where each are directed to the...

" Hmmm- Ok - Lets see. Im making an assumption that your problem is with the crosstab query? Do you know how to create a pivot table in Excel? " I know how to make it... Not really sure how it is used...

"In the "Players" table, I would include 2 fields. - Grade and Division. This is so that when players move to the next grade/division (At the end of the school year) you should be able to run an update query which A. Promotes the players to the next grade and B. Promotes only top grade (from the...

Thanks for the reply Statsman... A few things further, though Doing what you suggested gets me a list of one teams' players. Each score sheet needs to have both teams on it, with the list of players Let me try to concoct one on here... Team 1 Team 2 game 1...

I am in charge of a Dodgeball League for more than 150 kids. I have all the information put into tables in access 2003. The Tables are organized by division (3rd & 4th Grade, 5th & 6th Grade, etc...) so that on one table are all the 3-4 grade players. I have 4 total tables for 4 divisions...