By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Presenting queries results

P: n/a
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
Jul 19 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

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?

Jul 19 '06 #2

P: n/a
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

Jul 19 '06 #3

P: n/a
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" <ro******@hotmail.comschreef in bericht
news:11**********************@h48g2000cwc.googlegr oups.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

Jul 19 '06 #4

P: n/a
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" <ro******@hotmail.comschreef in bericht
news:11**********************@h48g2000cwc.googlegr oups.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


Jul 19 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.