Getting highest level output

#1 (**permalink**) 18-Nov-2005, 14:00 PM

Trying to output a string (A,B, or C) to a label on a report. In the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7680-getting-highest-level-output.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7680
highest letter code value??? Thanks for your responses.

Mike

#2 (**permalink**) 18-Nov-2005, 14:00 PM

How are you doing this --- in code? in DLookup function? in DMax function?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7680

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

--

Ken Snell
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7680

"MJc215" wrote in message
news:1132258945.284859.221640@g47g2000cwa.googlegr oups.com...
> 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
>