I'm trying to create a report based on a query.  The data source
(query and subsequent table) has about 15 columns and as many records.

I need to create a report that lists each record's primary key
followed by the results of any record that's <> null.  E.g.,

(primary key)
Blue
Red
Yellow

(primary key)
Red

(primary key)
Orange
Green

(primary key)
Pink
Blue
Black

I could easily do this with the report wizard or auto report; problem
is, however, that null records show up.  I could omit the null
records, but then I'll have spaces in between records.  Thoughts?

alex