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]