Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

include subquery in report?

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

  1. Alex Pavluck

    Alex Pavluck
    Expand Collapse

    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. OP
    John Vinson

    John Vinson
    Expand Collapse

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

    >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]
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page