Multiple fields greater than 0

[Lambo]

I'm sure this is probably simple but at this time of night i can't get my head round it.

I have a complicated query that shows 3 fields at the end with values. What i'm after is to not show if 2 of the fields have a 0 value in the same row to be excluded from the results.

 

[PNGBill]

Do you only want results where no more then One Field has Zero ?

I would tend to use a custom Function where you can use SQL/Query and Code to get your result.

 

[Lambo]

If all are 0 then i don't want the record to display, if any of them has a value of 1 or more then display the record.

 

[PNGBill]

If only Zero or above are options then you could add a Calculated Field to your Query that Sums the three fields.
Only Select records where the calculated field is >0

 

[Lambo]

Great idea, magic thanks