Poker Db/field is > other fields of 17

[Gerald Clare]

:blond: I am a mid-level FM designer so I know when I get the answer to this it's gonna be a 'doh!' minute, but I can't quite figure an elegant way to do this.

I've got seventeen number fields in each record - N1, N2,....N17 (representing the players scores [6 regulars 11 guests or former players]) I've got these numbers totalled and averaged. I'd like to automatically identify the high scorer.

So what kind of script or calculation will i.d. the high number?

Doh! in advance. Thanks.

Edited July 17, 2006 by Guest

[Wim Decorte]

calculation function:

max(N1;N2;...)

You might want to consider keeping the player scores in their own table instead of in 17 fields.

[Gerald Clare]

Way too late for that with over two hundred records. I need to work with the db I've got.