Minof Criteria

[cervantes008]

Hi All. I know this may seem quite simple, but I've been creating queries all day and I need somebody with a fresh head to figure this out.

I have a table that I'm tring to pull the Minof from a few columns but some of the columns are supposed to be null but are showing up as a 0 value. Is there a way I can grab the minof that is greater than 0?

Thanks in advance.

 

[Brianwarnock]

The Min option of the aggregate functions ignores null , how are you doing this ?

Brian

 

[cervantes008]

My table has a few columns with Number datatype. As the user enters values on a form, the column that user skips or leaves null will automatically give it a 0 value. When I take the table after the information is added, I query the minof and the 0 will always populate as the minimum because it is a value, 0 nonetheless. I want to be able to pull the minof value, bypassing any value less than or equal to 0..........instead of building another 2 queries to null the 0 values then pulling the minof.

 

[Brianwarnock]

So they are not Null but by default 0.
OK to do it in 1 query you need a where clause looking for >0.
To do this on the Design grid you have to pull the field twice, once for the Min and a second time for the Where.

Brian

 

[cervantes008]

You are the man Brian. Thanks.