Avatar of dianna Felton
dianna Felton
Flag for United States of America asked on

Minimun function in MS Access

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

Avatar of undefined
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?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
dianna Felton

ASKER
greater than 0
ASKER CERTIFIED SOLUTION
Patrick Matthews

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.