# Football Fixtures

G

#### gil_wilkes

I help to run a football league and we have 6 division (premier,1,2,3,4, &
5). What I would like to do is to generate fixtures for each division (Home &
Away). The premier league has 10 teams, Division 1 has 10 teams, Division 2
has 12 teams, Division 3 has 12 teams, Division 4 has 12 teams & Division 5
has 11 teams. I have a table with fields of team names and division.

N

#### NTC

generate 'fixtures' ?? what is a fixture ?

D

#### Duane Hookom

I believe the OP wants to create league schedules. There are lots of
in-expensive software packages for creating round robin and other types of
schedules. I would try to find one that can import and export data so Access
can be used.

G

#### gil_wilkes

Thanks for your help, I've sorted it out as:-

SELECT t1.TEAM AS HOME, t2.TEAM AS AWAY
FROM Teams AS t1, Teams AS t2
GROUP BY t1.TEAM, t2.TEAM
HAVING (((t2.TEAM)<>t1.TEAM))
ORDER BY t1.TEAM;

L

#### Lord Kelvan

there are a few problems with that query because i looked at this post
and tryed it myself

first it dosnt match divisions mine did but thats not the major
problem

the problem is that you get

home away
teama teamb
teamb teama

i couldnt figgure out a way to resolve this issue

Regards
Kelvan

M

#### Michel Walsh

Use > or < instead of <> (or = ) to break such symmetry. In fact, any
operator not symmetric would do.

Vanderghast, Access MVP

Reflexivity: a op a is true
Symmetry: if a op b is true then b op a is true
Transitivity: if a op b is true and if b op c it true then a op c is
true

op = , the three properties are observed
op >, only transitivity is observed