Deleting fields with query?

[scott]

I have a table with about 10 fields.....sometimes I only
use 2 of these fields and the other 8 fields are blank.

How would I build a query to only show those 2 fields that
have information in it and leave the other 8 fields off?

Thanks
Scott

 

[John Vinson]

I have a table with about 10 fields.....sometimes I only
use 2 of these fields and the other 8 fields are blank.

How would I build a query to only show those 2 fields that
have information in it and leave the other 8 fields off?

Umm... create a query selecting only those two fields!

If you mean that you want the query to dynamically change, so that
some records have two fields, and other records have six, and some
records have all ten - you can't. A Query must be homogenous; all the
records have the same "shape".

On a Report you can suppress the display of textboxes containing NULLs
- just set the CanGrow and CanShrink properties of the textbox to
True.