Fixture List Creator

[Jamie]

I have a table (Tbl_Teams) which contains teams - up to 26. I need a program
that creates a fixture list of the teams in Tbl_Teams, with each team playing
each other twice - home and away.
Has anyone done anything similar to this before? I dont really know where
to start. Perhaps the code could create a new table which has 3 fields,
home_team, away_team & Week_Number, and then populate these fields with the
fixtures.
Does anyone have any ideas? Thanks

 

[Tim Ferguson]

I need a program
that creates a fixture list of the teams in Tbl_Teams, with each team
playing each other twice - home and away.

Use Excel: put the teams in a row across the top, and then down the left.
Block out the diagonal where they are playing themselves.

Does that help?

Tim F