>Larry, thanks for your reply.
>
>I also need records , where there may be only one blank fld2 entry, so I dont think below will work.
>I got another reply on this thread which suggested using Max(fld2) whicj I think may work.. I'll give it a try.
>
>Regards,
>
>Gerard
>
If the values in fld2 are always going to be the same for each value in fld1 (i.e. AA corresponds to Widgets) then MAX will work. If there are going to be different values for the same value in fld1 (i.e. AA could have Diamonds or Widgets) then MAX will not work.

MAX will return the largets value in terms of ASCII value. This means that words that start with Z are larger than words that start with Y and so on. Also, capital letters are larger than lower case letters.