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?

 

[Tim1]

Hiya,

The easiest way to work out the points would be:

UPDATE table
SET POINTS = (FIXTURESWON * 3) + (FIXTURESDRAW * 2) + FIXTURESLOST

Tim

 

[jgoodman00]

If the value can be calculated, then there is no need to actually store the value. It is (apparently) more efficient to calculate values like this on the fly... James Goodman
j.goodman00@btinternet.com

 

[CosmoKramer]

James is right; it's not good practice to store calculated values when you can perform that logic anytime you want. When the underlying values are changed, the calculated values are not "automatically" updated to reflect those changes......