Hiding Zero or blank records

  • Thread starter Thread starter David Whitaker
  • Start date Start date
D

David Whitaker

Is there a way to hide specific rows that contain blank or zero values based
off of several fields in a specific record.
There are about six different textboxes associated with specific fields that
sometimes may be blank or contain zero values. I am wanting not to show a
record for those, is this possible?
 
Put the following criteria in each field but in a different row for each
field:
Not 0 Or Not Is Null
The query will not return any record that has a 0 in any of the six fields
or is blank in any of the six fields.

BTW, I am in busineess to provide customers with a resource for help with
Access, Excel and Word applications. If ever you need consulting help,
contact me at my email address below.
 
In a different row did the trick.
Before I did think of Not 0 Or Not Is Null, but I didnt put it in a
different row in each field in the query.
Thanks
 
Criteria in different rows gives you something like this:
This Or That Or The Other Thing
Criteria in the same row gives you comething like this:
This And That And The Other Thing

When you put Not 0 Or Not Is Null in the same row for all six fields, your
query only returned records that had a 0 or blank in all six fields.

Steve
PC Datasheet
 
Back
Top