How to execute multiple queries in 1 report

N

naveen prasad

Dear all,
Good day...
kindly help me in this.

I want to prepare a report executing multiple queries.
like I have 3 different queries which will give different results,but I want
to show them in 1 report.

kindly help me how it is possible.

regards
 
A

Allen Browne

If you cannot combine the 3 queries into one (e.g. with a UNION query), you
could add a couple of subreports to show the data from the other 2 sources.
 
N

naveen prasad

I didnt get u dear
I dont want to join all the queries with union, i want all them to be
individual only,

but i want to show all the results of queries in 1 report ....

Kinldy clarify how can i make it
 
J

Jeff Boyce

As Allen explained, create a report from each query, then embed two of them
as sub-reports in the third.

--

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
N

naveen prasad

Noted jeff, & allen, thankyou for your kind support

I did the same and i got the result perfectly....

Excellent...

regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make report 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
To make pdf to work as word 1
Tracked changes by multiple people modified to one 0
How to implement two shifts per day with multiple teams 0
I can't to access the supplements (addin) and controls 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Multiple Queries to Multiple Reports 1

Top