Adding query fields to existing reports

Question

I have created a report based on a query. Is is possible to add fields from a different query to this report after it has been created? I see that I can add additional fields from different tables through the Field List, but see no where to select fields from other queries.

Thanks.

Answer 1

I understand how to work with a report that already contains multiple queries - I just want to know if I can add additional fields from queries.

If it isn't possible, I suppose I'll make a 'master' query containing all of the fields that  I need taken from the smaller queries before I start making any report.

Answer 2

You need to create a query that supplies the required data to the report.  That often needs more than one table/query to gather records from wherever they are stored.  Play areound creating queries with two or three tables to get a feel for it.

Then you can use the report's Sorting and Grouping to to group records a little like a subreport.  Experiment by creating report's directly in design view and using a query you created in the above exercise.

Once you get hints about how to do something, go into trial and error mode to see how things fit together.

Answer 3

Thanks - I ended up going with a subreport.

Is there an easy way to add query fields to reports when making the report from scratch (ie. not using the report wizard)? and without using subreports

Answer 4

Your question seems a bit vague as to what you really want to achieve.

perhaps you could look at using combo boxes in the report to collect data from other tables / queries

cheers

PaulG

Answer 5

Several options - You can join the queries or use a subreport.

In either case you need a common field.