Getting highest level output

M

MJc215

Trying to output a string (A,B, or C) to a label on a report. In the
query that the report is being produced from I have a member name field
and LetterCode field that is the focus of obtaining my A, B, C output.
Lets say I have 3 records with the same member name but each has a
different LetterCode. I want to output to the label the highest
LetterCode(C being the highest) to the label on the report. The way i
have it set up now is with an IIf but it automatically takes the first
LetterCode value of the member name. How can i have output the members
highest letter code value??? Thanks for your responses.

Mike
 
K

Ken Snell [MVP]

How are you doing this --- in code? in DLookup function? in DMax function?

DMax function will probably give you the result that you seek.
 
Top