unbound reports

[unclefink]

Im trying to create a report that will require data from several different queries. In the past, i've created a report and then bound the data source to a specific query.

Because of the amount of data necessary to create this report from different queries, I figured if I didnt bound the report to any query but to make each individual text box point to the data source.

My question is, how do I go about forcing a text box to pull data from a specific record, with different text boxes referencing different query sources.

Any help is greatly appreciated.

Thank you in advance.

 

[plog]

I'm not entirely convinced this is the way to go--I bet there can be a more elegant/efficient/pretty solution that either requires a complex query or some sub-reports. However, the way to do it the way you have requested would be by using DLookups (http://www.techonthenet.com/access/functions/domain/dlookup.php).

 

[unclefink]

I think you are right. What I was trying to do was get my report without having to create so many queries to put together all the data required to implement the report. In Some cases, i've got almost 12 fields in a query which is gather data from other queries as i have to break my data up between three different sites. I'm probably looking too deep into the necessity of what i am trying to do vs. what will get the job done.