Getting highest level output

  • Thread starter Thread starter MJc215
  • Start date Start date
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
 
How are you doing this --- in code? in DLookup function? in DMax function?

DMax function will probably give you the result that you seek.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highest value on report 4
Field Value based on highest value 3
IPhone sound quality gets worse each generation 5
Compare Fields 1
Help with getting data from a table 3
Steam user spends $13,000 to get to Steam's highest level 2
Looking up the highest values. 1
Printing a Report 2" X 4" 3

Back
Top