display name and use max

[Cricket]

making a sheet for bowling need to find high score, Using max is easy.After
high score need to display bowlers name (same row diffrent column?) Cant get
bowlers name to display??? pls HELP

 

[Sharkbyte]

Try this...

DLookup("[NameField]", "[tblName]", "score = DMax _("[ScoreFieldName]",
"[tblName]"))

Or, get your High Score, set it in a variable and replace the DMax statement
w/ the variable name.

As an aside...My parents knew someone name Cricket, in bowling circles,
married to a man named Pete. Any possibility of being the same person? =)

Hope my response helped.

Sharkbyte
(e-mail address removed)