Reports - Displaying values that are not null

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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]
 
Back
Top