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

Is Not Null in the criteria for those fields.

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