At this point I cant change the structure of the table.

The max function in fox 8 will not let me put more that one column as a

parameter.

Unless im doing something very wrong that is.

Now I could just do it in fox code but there is no fun in that ?

;)

Thanks for the help.

Anthony Testi wrote:

>Were then my suggestions of any help?

>

>

>

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

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

>>

>>

>

>

>

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

>>

>>Anthony Testi wrote:

>>

>>

>

>

>--- StripMime Report -- processed MIME parts ---

>multipart/alternative

> text/plain (text body -- kept)

> text/html

>---

>

[excessive quoting removed by server]