Welcome to SPN

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

Sign Up Now!

include subquery in report?

Discussion in 'Information Technology' started by Alex Pavluck, Nov 10, 2005.

  1. Alex Pavluck

    Alex Pavluck
    Expand Collapse
    Guest

    I am using a query in access and then using a subquery to add a '+' at
    the beginning of each row to display additional information. How do I
    add the subquery information to a report?
     
  2. Loading...

    Similar Threads Forum Date
    Jainism Jains included as a minority community under Section 2(c) of the NCM Act, 1992 Interfaith Dialogues Jan 21, 2014
    Intolerance, religious unfamiliarity lead to severe bullying of local student (includes TV video of Sikh Youth Nov 6, 2010
    Atheism Interfaith dialog must include atheists Interfaith Dialogues Oct 9, 2010
    India Include peace corridor in Indo-Pak talks: Sikhs Breaking News Jun 22, 2010
    World Admirers of King include area Sikhs Breaking News Jan 18, 2010

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On 9 Nov 2005 07:34:29 -0800, "Alex Pavluck" <apavluck@gmail.com>
    wrote:

    >I am using a query in access and then using a subquery to add a '+' at
    >the beginning of each row to display additional information. How do I
    >add the subquery information to a report?


    Do you mean a Subquery - or a Subdatasheet? I'm guessing the latter!

    Rather than trying to use the (very limited) datasheet capabilities in
    your Report, consider basing the Report on a Query joining your two
    tables. Use the Report's Sorting and Grouping dialog to group by the
    main table's information; put fields from the main table in the
    section header for that table, and the detail records from the second
    table in the Detail section of the report.

    John W. Vinson[MVP]
     

Share This Page