Recordas not to show

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I have query result with some records that have the same date and time, some
of them they have values and others are zero. I would like to keep just th
eone with values. the problem is that I have other with zero values that are
valid.

If you can paste this into Excel will much clearer.

Thanks,

Dan

Field2 Field3 Field4 Field5 Field6 Field7 Field8 Field9 Field10 Field11 Field12
75 45 0 0 4471 787 2 5 37 11/1/2004 3:30:41 PM
0 0 0 0 0 0 0 0 0 11/1/2004 3:30:41 PM
189 142 0 0 17879 34573 3 10 86 11/1/2004 3:27:22 AM
325 255 0 0 19662 84787 3 18 144 10/27/2004 1:41:11 PM
0 0 0 0 0 0 0 0 0 10/27/2004 1:41:11 PM
0 0 0 0 0 0 0 0 0 10/15/2004 9:48:50 AM
75 45 0 0 4471 787 2 5 33 10/14/2004 3:38:49 AM
0 0 0 0 0 0 0 0 0 10/14/2004 3:38:49 AM
0 0 0 0 0 0 0 0 0 10/12/2004 12:16:35 PM
0 0 0 0 0 0 0 0 0 10/5/2004 8:51:38 AM
113 86 0 0 16557 15485 3 5 55 10/1/2004 3:52:15 PM
0 0 0 0 0 0 0 0 0 10/1/2004 3:52:15 PM
 
-----Original Message-----
Hi:

I have query result with some records that have the same date and time, some
of them they have values and others are zero. I would like to keep just th
eone with values. the problem is that I have other with zero values that are
valid.

If you can paste this into Excel will much clearer.

Thanks,

Dan

Field2 Field3 Field4 Field5 Field6 Field7 Field8 Field9 Field10 Field11 Field12
75 45 0 0 4471 787 2 5 37 11/1/2004 3:30:41 PM
0 0 0 0 0 0 0 0 0 11/1/2004 3:30:41 PM
189 142 0 0 17879 34573 3 10 86 11/1/2004 3:27:22 AM
325 255 0 0 19662 84787 3 18 144 10/27/2004 1:41:11 PM
0 0 0 0 0 0 0 0 0 10/27/2004 1:41:11 PM
0 0 0 0 0 0 0 0 0 10/15/2004 9:48:50 AM
75 45 0 0 4471 787 2 5 33 10/14/2004 3:38:49 AM
0 0 0 0 0 0 0 0 0 10/14/2004 3:38:49 AM
0 0 0 0 0 0 0 0 0 10/12/2004 12:16:35 PM
0 0 0 0 0 0 0 0 0 10/5/2004 8:51:38 AM
113 86 0 0 16557 15485 3 5 55 10/1/2004 3:52:15 PM
0 0 0 0 0 0 0 0 0 10/1/2004 3:52:15 PM
.
Click to expand...
 
You should define which fields a basic criteria for your
acceptable result. In this fields put >o or <> 0
 
Back
Top