Input of data into a report

[Guest]

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
palyer makes each game.

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!

 

[Guest]

You should be able to build queries to pull your data, then make a report
using the wizard based off of your queries. Will this work?

 

[Guest]

Another board I posted on gave me info on how to do the "report off of a
query", but i still cant figure out how to get two different lists of team
members onto one report

example (hopefully this stays formatted...):

team 1 team 2
john [scores] bill [scores]
joe [scores] bob [scores]
jill [scores] blake [scores]

I figured out how to get one team list, but i need both team lists on the
same report wish a table grid next to each name for space to write their
individual scores.

Also, Above this section, I need a section that puts each team name above a
table grid for the team scores to be written in

example:

Bulldogs Ligers
[score 1] [score 1]
[score 2] [score 2]
[score 3] [score 3]