excluding an empty field

[310que]

Is there a way to run a query that will not show the fields that are empty ?

 

[David R]

Is Not Null in the criteria for those fields.

 

[Pat Hartman]

You can eliminate rows that contain nulls in a particular column but you cannot vary the columns that a query returns.