Help with Report

[alex]

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

 

[Sharkbyte]

Try using a report with a subreport.

For the criteria, on the primary report, include Primary Key, and an Is Not
Null on the other column(s). Then use the subreport for your data, and link
it to the Primary Key, in the main body.

Sharkbyte