Only displaying non-null fields in query??

[skier4life]

So I have a large database with the top 300 timberland owners with acreage broken out by state. I want to do a query where I can look up a specific owner and see which states they own land. The problem is, I only want to display the state fields that have acreage in them. is there any way to do this? right now if I enter "is not null" into the state fields it wont display the record at all if any of the state fields are blank. Thanks!

[rzw0wr]

Try is not null in each field.
Use different lines to make it OR.

When using the SAME line it is an AND.
When using a different line it is an OR.


Dale