"Mandoskippy" wrote:

> Howdy, I think this will be aneasy question. I want to return the Max
> of three database fields.
>
> I might have Serious = 20 and Medium = 10 and Low = 30
>
> In that case I want it to return 30.
>
>
> if it is Serious = 2 Medium = 0 and Low = 5
>
> I want it to return 5
>
>
> If it is serious = 0 Medium =10 Low =3
>
> I want it to return 10.
>
> I am looking at the Max function (aggregate) and can't figure out the
> syntaxt. Any help would be appreciated.
>