Null - Records to not display

J

Joey

I have 110 rows of data with about 20 columns. The first column is Name and
the rest of the columns are requests such as Apples, Oranges, Bananas...

What I want to do is run a query that will only display the Name row if
there are selections listed in the columns because in some name rows all the
columns are blank.

Is there a Criteria I can add?

Thanks
 
J

Jeff Boyce

Joey

That sounds like a spreadsheet, not a well-normalized relational database
table.

Is there a reason you aren't just using a spreadsheet?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

KARL DEWEY

Try adding a calculated field in the design view like this --
Expr1: [Field1]+[Field2]+[Field3]+[Field6]+[Field5]+[Field20]
Criteria >0
 
Top