Report On Multiple Queries

[singingshiver]

I want to create a report based on values in multiple forms. How do i do this?

 

[Robert Dunstan]

Create a new query that is based on your multiple queries then base your report on that new query

 

[singingshiver]

That won't work

The queries I have are linked to forms that create totals. Then it is these multiple forms that need to be represented in a report.

 

[Autoeng]

Point the criteria of your queries to the form fields that you need information from. Then create a new query using all of the other queries to bring them into one datasource for the report.

Autoeng

 

[singingshiver]

Let Me Expand

This is what I am trying to do:

I have created various forms based on various queries to count the amount of records in each query. So effectively I have forms with a text box that simply displays a numeric value for the amount of records in the query it is linked to.

With these various forms, I need to link the value in each text box on each form to a report to display all the numerical values.

I may be going a long way about this, can anyone help???

 

[Autoeng]

Forget the forms. Create Total queries of you queries. Create a giant query to pull all of the total queries together. Use that as a basis for your report.

People don't seem to get the point that a lot of times you have to build multiple queries to get the information in the specific format that you want. You have to think about how the information gets to the final format and create queries to perform all of the changes that need to take place.

For example. Create a query that displays all dogs of the Lassie breed. Create a query to count the records found in the forst query. Now you can pass the count to a report.

Autoeng