Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Reports - Displaying values that are not null

Discussion in 'Information Technology' started by marc, Jul 28, 2006.

  1. marc

    marc
    Expand Collapse
    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?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 3 Jul 2006 07:29:02 -0700, marc
    <marc@discussions.microsoft.com> wrote:

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

Share This Page