League Table

[GRUTES]

How would I create a league table in Microsoft access? I need field names:

PLAYER NAME
FIXTURES PLAYED
FIXTURES WON
FIXTURES LOST
FIXTURES DRAWN
GAMES FOR
GAMES AGAINST
POINTS

I would need the players names, fixtures played, won, lost, drawn, for and
against to be collected from other tables. The points column would need to
be calculated - 1 point for a loss, 2 for a draw and 3 for a win.

Uncle Jack said about calculating the points during a query but how would i go about getting access to add points up according to the rules I stated previously?

How would I go about this because i haven't got a clue?

 

[THoey]

I would create multiple tables:

tblPlayers
PlayerID
FirstName
LastName
...

tblFixtures
FixtureID
FixtureType
...

tblMatches
PlayerID <-- Foreign Key to tblPlayers
FixtureID <-- Foreign Key to tblFixtures
Result
...

Based on these three tables, You can run several queries to get the other values.

Take that as a start and see where you can get... Terry M. Hoey