I have 3 fields that have either a 0 or is null or have a value ~ How can select the lowest value among the 3 fields in MS Access query? example:
Field 1 Field 2 Field 3 Minimun value would be:
0 35.75 35.75
15.01 14.39 0 14.39
9.56 7.59 6.59 6.59
Microsoft ApplicationsMicrosoft Access
Last Comment
Patrick Matthews
8/22/2022 - Mon
peter57r
Do you regard Null and 0 as the same or what?
dianna Felton
ASKER
no they are separate. I would evaluate for either a Null value or a 0 value
peter57r
So if they are to treated the same , do want null to be greater than 0 or less than 0?