Excluding nulls in a query

[Guest]

I am trying to query a table that has sevral fields that are filled in
depending on how big the order is so there may be a few fields that have no
data entered. Is there a way to only show the fields that have been filled
in? Right now when I put the Criteria Is Not Null the whole thing comes up
blank.
Any help would be appreciated.

 

[John Vinson]

I am trying to query a table that has sevral fields that are filled in
depending on how big the order is so there may be a few fields that have no
data entered. Is there a way to only show the fields that have been filled
in? Right now when I put the Criteria Is Not Null the whole thing comes up
blank.
Any help would be appreciated.

A Query either returns all of the fields in the record, or none of the
fields in the record. Just like a Table, all of the records in a
query's recordset must have the same "shape" - you can't have a query
where some records have 8 fields and other records only have 5.

What do you mean by "only show the fields"? Are you looking at a query
datasheet, a Form, a Report, or what?


John W. Vinson[MVP]