How to execute multiple queries in 1 report

[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

 

[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.

 

[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

 

[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

 

[naveen prasad]

Noted jeff, & allen, thankyou for your kind support

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

Excellent...

regards