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.
Each column on the tables are: Last Name, First Name, Team
For each game every week, I have to print out Scoring Sheets. As i have it
right now, I have the scoring sheet created using Tables in Word 2003, and I
have to Type in all the names and team names. The scoring sheet consists of
the two team names with area to write in team scores, and then another table grid listing each teams' players and space to write in how many outs each player makes each game.
This process is very long, as there are 8 games with 16 teams playing every week.
My question is this: Is there a way to have Access fill in all the names and
team names on a scoring sheet? I'd like to have it so I just have to type in
which teams are playing each other, and have it print out the scoring sheet,
completely filled in.
Do I have to design some type of 'report' in access? or can I somehow import
the Access data into the Word document (with the data going into the Word
Table grids)?
Please Help me!
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.
Each column on the tables are: Last Name, First Name, Team
For each game every week, I have to print out Scoring Sheets. As i have it
right now, I have the scoring sheet created using Tables in Word 2003, and I
have to Type in all the names and team names. The scoring sheet consists of
the two team names with area to write in team scores, and then another table grid listing each teams' players and space to write in how many outs each player makes each game.
This process is very long, as there are 8 games with 16 teams playing every week.
My question is this: Is there a way to have Access fill in all the names and
team names on a scoring sheet? I'd like to have it so I just have to type in
which teams are playing each other, and have it print out the scoring sheet,
completely filled in.
Do I have to design some type of 'report' in access? or can I somehow import
the Access data into the Word document (with the data going into the Word
Table grids)?
Please Help me!