It is a date column. My query must return the data in that format.

Anthony Testi wrote:

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