I have 6 fields on a form that uses DLOOKUP from qry to gather the highest
number within a qry (second field in below example). I need to compare the
6 fields to find the highest number then display information from all related
fields that equal that number (display first section in below example).
Example...

[Hello] [5]
[bye] [3]
[hello again] [5]
etc...

Final output is "Hello, hello again"

See the MaxOfList() function at:
http://allenbrowne.com/func-09.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"LightShow" <(E-Mail Removed)> wrote in message
news:6CBD6ECA-B118-43E9-B119-(E-Mail Removed)...
> I have 6 fields on a form that uses DLOOKUP from qry to gather the highest
> number within a qry (second field in below example). I need to compare
> the
> 6 fields to find the highest number then display information from all
> related
> fields that equal that number (display first section in below example).
> Example...
>
> [Hello] [5]
> [bye] [3]
> [hello again] [5]
> etc...
>
> Final output is "Hello, hello again"