Query Criteria

[Alex Motilal]

Hi Everybody,
I have a query with six columns. The first column is item description and the next five columns are numeric fields. In some rows, certain numeric fields have zero and the other columns have some integers. In some rows all the five columns have have zeros.
Is it possible to hide the rows only where all the five numeric field collumns have zeros?


Thanks in advance

[weekend00]

How do you want to hide them? delete them from the table or exclude them in a query/report/form?

generally, use a where clause ( if there is no null in any field of any record):
... where field2=0 and field3=0 and field4 =0 and field5=0 and field6=0

[Alex Motilal]

I solved the problem by adding the respective columns in the query grid, and put <>0 as criteria