Eyal I am unable to call at this time.

Just remember one thing though. I dont want to use foxcode to do this.

Just SQL.

There lies the trick my friend ;)

Eyal Sela wrote:

>

>

>Hi AJ,

>give me a call to my office- i think i know how to pull this off- (giving that i

>understand what the hell you're talking about..... :) )

>the number is listed below....

>

>Eyal Sela

>Clinical Programmer Analyst

>

>Bayer Pharmaceuticals Corporation

>Phone: 203 812-3872

>Fax: 203 812-2953

>eyal.sela.b@bayer.com

>

>

>

> aj

> <aj@medicaldirect To: profox <profox@leafe.com>

> or.com> cc:

> Sent by: Subject: [NF] SQL question

> profox-bounces@le

> afe.com

>

>

> 05/24/2004 01:49

> PM

> Please respond to

> ProFox Email List

>

>

>

>

>

>

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