AJ:

I may have missed read your posting you said:

"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"."

I was thinking that it was date COLUMN. So my comments may not apply,

sorry.

Anthony

> -----Original Message-----

> From: aj [mailto:aj@medicaldirector.com]

> Sent: Monday, May 24, 2004 9:50 AM

> To: profoxtech@leafe.com

> Subject: [NF] SQL question

>

>

> 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.

>

>

>

>

[excessive quoting removed by server]