1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to use many query in one report

Discussion in 'MS Access' started by dododo, Jun 30, 2011.

  1. dododo

    dododo New Member

    Joined:
    Jun 24, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    I have many query and i wan to show a lot of query in one report. How can i do that? I designed report by my own and want to bound it with many query. Please tell me how to do it.

    Please see the link of my report. Each rows and columns of my report need to bound with one query.

    ww.postimage.org/image/xatfswas
     
  2. Webdeveloper

    Webdeveloper New Member

    Joined:
    Jun 22, 2011
    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    0
    Occupation:
    IT Professional
    Location:
    New Delhi
    Home Page:
    Hi,

    Since there are fixed number of queries to be executed and the result shown in a particular order, so what you can do is you can first execute all the queries save the result in respective variables and then use the variables to show in the report matrix.

    Cheers,

    ~Maneet
     
  3. jaydeee

    jaydeee New Member

    Joined:
    Aug 18, 2011
    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    0
    I know this is and old thread but I just wanted to share what I am do in this scenario.

    I simply create another query to combine all the queries I've made in one and use it as the recordsource in my report. that is one approach.

    Anotherone is to have mini or subreports put all together in one main report.

    My scenarios were mostly include total and subtotal that I wanted to put in one report so the first option is best for me. however if you're joining a datawindow, then subreport is your best option.

    hope it helps.
     
  4. Orion

    Orion New Member

    Joined:
    Oct 5, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Home Page:
    Increase the columns of your report. make it look attractive.. as i take a look at your report . it doesn't seems to be interesting.
     

Share This Page