Get Minimum value except for 0 (zero)

[cpampas]

Hello,
Is there a simple way to get the minimum value in a query except for the zero values ? (without changing the query)
the result of my query is: 25,18,6,13,0,40,0

I am using : DMin("cot", "qryline") wich returns the value 0(zero)
but I want the minimum, except for zero values, that is to say number 6
Any thoughts ?

 

[theDBguy]

Hi. Have you tried using?

DMin("cot","qryline","cot>0")

 

[cpampas]

Thank you, it works great

 

[theDBguy]

Thank you, it works great

You're welcome. Good luck with your project.