Report Data Source

[mvpejp]

I am creating a report based on a multiple number of queries. The majority of my data comes from Query 1. However I do have some numbers from other queries that I want to include on the same report. Can I have the control on the report be linked to an alternate query if so how is this done.

Any help is appreciated thank you.

MVPEJP

 

[Hayley Baxter]

Can't you have the one query taking all the tables you need and joining them in your query. This will then allow you to take data from multiple tables and base your report on the one query.

You can maybe try using a subreport to show the data and base the subreport on Query 2 if requried but these are usually used for showing the many side of a relationship. I am not familiar with the data you are working with

Hay

 

[gdanalakshmi]

DId you come up with a solution to do this?

 

[Fornatian]

if Hayleys suggestion doesn't work, although it is the most efficient why can't you just just drop the values from your other queries as separate subreports or use DLOOKUP to get the values you need?