Reports - Displaying values that are not null

[Guest]

I would like to print a report that displays a list of the values which are
NOT null for each record.

For example, if a person likes apples and oranges, but not bananas, I want
to see a list that says: Name, apples, oranges.

Is this possible?

 

[John Vinson]

I would like to print a report that displays a list of the values which are
NOT null for each record.

For example, if a person likes apples and oranges, but not bananas, I want
to see a list that says: Name, apples, oranges.

Is this possible?

You can use some VBA code to concatenate a list of values.

http://www.mvps.org/access/modules/mdl0004.htm

Since you don't say how your table is structured I'm not certain this
is the right answer for your question - if not post back with a bit
more detail.

John W. Vinson[MVP]