Access-calculated field

[PeteMc]

I have [Goals For]and [Goals against] fields for each game to be played, how can I calculate the [Points] field so that 3 is awarded for a win, 1 for a draw and 0 for a loss
PeteMc

 

[LittleSmudge]

Don't

or should I say DON'T

Calculated fields are totally against the whole principle of Relational Database design ( Normalisation Rules, Codd, etc.. )


On a Form or report you can then display the points value by using something like a nested IF statement in the ControlSource

txtPoints = If(GoalsFor>GoalsAgainst,3,If(GoalsAgainst>GoalsFor,0,If(GoalsFor=0,1,2)))



By the way - see FAQ FAQ700-2190 about why to avoid EVER putting space characters in object names.



'ope-that-'elps.







G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[PeteMc]

Thanks LittleSmudge, big help. Take your point about Dr Codd.