<div>
Do you regard Null and 0 as the same or what?
</div>


<div>
no they are separate. I would evaluate for either a Null value or a 0 value
</div>


<div>
So if they are to treated the same , &nbsp;do want null to be greater than 0 or less than 0?
</div>


<div>
<div class="content wysiwyg-content">
I have 3 fields that have either a 0 or is null or have &nbsp;a value ~ How can select the lowest value among the 3 fields in MS Access query? &nbsp;example: <br />
Field 1 &nbsp; &nbsp; &nbsp; Field 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Field 3 &nbsp; &nbsp; &nbsp; Minimun value would be:<br />
0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;35.75 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;35.75<br />
15.01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14.39 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14.39<br />
9.56 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7.59 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6.59 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6.59
</div>
</div>


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

Do you regard Null and 0 as the same or what?

no they are separate. I would evaluate for either a Null value or a 0 value

So if they are to treated the same ,  do want null to be greater than 0 or less than 0?

Minimun function in MS Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.