record selection and report question

[Susan]

I have a table with records that contain name and seven columns beside each
name. The seven columns are numeric fields. I created a report based on
this table

Name Col1 Col2 Col3 Col4 Col5 Col6 Col7

I would like to show the detail records for only those that have a number in
any of the seven columns. In other words I do not want to list in the
report any record which
Col1 and col2 and col3 and col4 and col5 and col6 and col7 are null or zero.
How do you do that?

Thank you!
Susan

 

[Jerry Whittle]

Create a query based on the table.

In the criteria for each of the fields in question put:

0

Make sure that you put all seven on the same criteria line.

Base the report on this query.

 

[Susan]

I am very new to the query. I open the Query in Design view and I see the
Name and the Col1 Col2 Col3 Col4 Col5 Col6 Col7 down in the bottom part of
the screen. If I place a >0 in the Filter for Col1 and look at the
datasheet, then I have all those of Col1 showing, but then if I tab over to
Col2 and add the >0 then I do not see any records in the datasheet view so
it is like I am narrowing my selection criteria instead of broadening it. Is
it working like show this if Col1 is >0 and Col2>0? I obviously am not doing
this right! Please advise!

 

[Jerry Whittle]

First allow me to apologize. I misread your question and sent you down the
wrong path.

Instead of putting the > 0 for the criteria of each field all in the same
row, you need to drop down a criteria row for each. That makes it an OR
statement so that if any of the fields are greater than 0, it will show that
record. It should look something like this:

Col1 Col2 Col3 etc.

 

[Susan]

I tried that but it is not working. I get less records when I start adding
the >0 to each under the Or. I have not figured out the difference in the
Filter and the Or with the results in the datasheet view that I am
receiving.