Presenting queries results

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • john
    #1

    Presenting queries results

    I have a about 15 different numbers (which are the result of 15 query
    calculations (queries on different tables)) which I want to present in a
    report. What would be the easiest way to get those values from the query
    into one report? I don't seem to be able to base a report on more than one
    query. I'm rather new to Access and I have no VB experience so I hope it can
    be done without it.
    Thanks,
    john


    Tags: None
    • pietlinden@hotmail.com
      #2
      Re: Presenting queries results


      john wrote:
      I have a about 15 different numbers (which are the result of 15 query
      calculations (queries on different tables)) which I want to present in a
      report. What would be the easiest way to get those values from the query
      into one report? I don't seem to be able to base a report on more than one
      query. I'm rather new to Access and I have no VB experience so I hope it can
      be done without it.
      Thanks,
      john
      are the queries radically different? Or are only the filters
      different? What kinds of calculations are you doing? The information
      you have provided is not enough to suggest a solution. Are you
      querying the same tables each time?

        Comment

        • Ron2006
          #3
          Re: Presenting queries results

          Is there basically only one answer/record resulting from each of the
          Queries?

          I have never tried this with so many quieries, but if there is only one
          record resulting from each query then simply drop all of the queries
          onto a single 16th query and select the numbers you want.

          Dirty I am sure, but it may work.

          Files do not have to be related for the query builder to allow you to
          see them in the result.

          Basically we need more information.

          Ron

            Comment

            • john
              #4
              Re: Presenting queries results

              I have a about 15 different numbers (which are the result of 15 query
              calculations (queries on different tables)) which I want to present in a
              report. What would be the easiest way to get those values from the query
              into one report? I don't seem to be able to base a report on more than one
              query. I'm rather new to Access and I have no VB experience so I hope it can
              be done without it.
              Thanks,
              john

              "Ron2006" <ronnemec@hotma il.comschreef in bericht
              news:1153336132 .814190.190700@ h48g2000cwc.goo glegroups.com.. .
              Is there basically only one answer/record resulting from each of the
              Queries?
              >
              I have never tried this with so many quieries, but if there is only one
              record resulting from each query then simply drop all of the queries
              onto a single 16th query and select the numbers you want.
              >
              Dirty I am sure, but it may work.
              >
              Files do not have to be related for the query builder to allow you to
              see them in the result.
              >
              Basically we need more information.
              >
              Ron
              >

                Comment

                • john
                  #5
                  Re: Presenting queries results

                  All queries count the number of records for certain criteria. The queries
                  have only one number as a result. Some of the queries are based on one
                  table, other on 2 or more linked tables.
                  I fiddled with basing one overall query on other unrelated queries and in
                  fact that works, even with queries based on more than one table. Amazing!
                  Now I can create my pyramid-like report which starts with the total number
                  of my main entity and beneath it showing other group counts, and group
                  counts on those group counts....etc.. .
                  Thanks guys.
                  john

                  "Ron2006" <ronnemec@hotma il.comschreef in bericht
                  news:1153336132 .814190.190700@ h48g2000cwc.goo glegroups.com.. .
                  Is there basically only one answer/record resulting from each of the
                  Queries?
                  >
                  I have never tried this with so many quieries, but if there is only one
                  record resulting from each query then simply drop all of the queries
                  onto a single 16th query and select the numbers you want.
                  >
                  Dirty I am sure, but it may work.
                  >
                  Files do not have to be related for the query builder to allow you to
                  see them in the result.
                  >
                  Basically we need more information.
                  >
                  Ron
                  >


                    Comment

                    Previous template Next
                    Working...