query (1 Viewer)

[Thedon123]

I have query with value

A B C D E
0 1 2 3 1
0 0 0 0 0
1 2 0 9 0
0 0 0 0 0
0 0 0 1 1
1 0 0 0 0
0 0 0 0 0
0 0 0 0 0

I need to filter out all the 0 0 0 0 0 records from the query

how would i do that.
A B C D E repsent trhe different fields

 

[Mile-O]

By using the OR criteria in the query builder, just drop a row with each criteria on each field.

  A        B        C         D          E
<>0   
          <>0
                     <>0
                                <>0
                                            <>0

 

[gblack]

What do you mean by filter out the Zeros?

Are the numbers actual numbers, or are they a count of each column? If all you want to do is get a sum of each column A, B, C...
Just click on the sigma button in the query design and choose "Sum" from the "Group By" drop down choices below.

If not... what do you mean by filter out?

 

[gblack]

OOPs! Sorry Read it wrong....

I believe you need to do it like this to get rid of all the 00000 records:

A B C D E
<>0 <>0 <>0 <>0 <>0
<>0 <>0 <>0 <>0 <>0
<>0 <>0 <>0 <>0 <>0
<>0 <>0 <>0 <>0 <>0
<>0 <>0 <>0 <>0 <>0

 

[gblack]

OK Im a true idiot and its too early in the am for Access probs.

All you need is one line

<>0 <>0 <>0 <>0 <>0 <>0


UG!