G
Guest
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"
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"