I am using foxpro but its a SQL question anyway.

Ive googled my a$$ off on the topic but cant seem to find an answer.

I have a table with a few date columns for payment dates. I need to get

the highest value out of this table and display it as a single column in

my query. On top of that, each date row determines who paid the bill.

An attorney a doctor etc. and mark the returned data as such ex

"10/24/05 ATT".

Anyone been down this road before.