Many queries... Now I want to display results in a report!

[Guest]

I have created about 10 queries from the same table (they are just numerical
totals). But now I would like to display the results of each query in one
report. How do I do this?

 

[Guest]

I'm not sure why you needed 10 queries or how they are similar or different.
However, you can create a subreport based on each of the 10 queries and then
add these 10 subreports to an unbound main report.

 

[Guest]

Well maybe there is an easier way to do what I need?

My database is a pilot logbook. I am using queries to give me the sum of the
"Flight Time" field when various conditions are met. For example: I want to
figure out how much solo time I have. So, the query only returns records
where the "Solo" field = Yes (Yes/No field). One query returns each record
(each individual solo flight). A second query is a totals query which just
gives the sum of the "flight time" field for those records, not each
individual record (this is the data I am really looking for). So I have a
number of queries like that, and I just want to bring each individual sum
back together in one report...

Thanks

 

[Guest]

I am not sure what all your queries are but it may not be possible to roll
them into a single "record source" of a union or other query.