Hi people,
I have 3 fields in one table and i would like to have at the some time the max of this fields. Can you help me?
Regards
insea
Hi people,
I have 3 fields in one table and i would like to have at the some time the max of this fields. Can you help me?
Regards
insea
just a guess, but are you looking at something like
[VBA]
SELECT MAX(f1)+MAX(f2)+MAX(f3) as MaxSum FROM [sometable]...
[/VBA]
where I think you need to account for Null values etc....
That's exactly what i need.
Thanks a lot.
Regards
insea