>Don,
>
>I don't believe you can use MIN(v1,v2) in a select, You use MIN(field) and it compares all contents. Youl have to select MIN(f1), MIN(f2) then get the minimum from those values.
>
>-Tom

Thanks, I forgot that MIN() and MAX() were reserved SQL commands and are basd on aggregate purposes. I have changed it to IIF() but thought I was going crazy... Just one of those duplicate functions names with different uses.