Multipul Query int Report Problem.

[phillsheen]

Hi,
I've not done many reports in the past so Im a bit of a novice. Im having problems getting fields from 3 differnt queries into my report. Now the first problem Im having I think is something to do with the fact that these 3 queries are created from one other query. Basically I have a main query that filters all the data that I need from my main table and then Im using 3 seperate querys to filter it down again. Have I gone about this the right way?

So what I ultimatly want is the report to display all the information in all 3 queries.

Any advice or links to tutorials would be fab!

Cheers
Phill

 

[phillsheen]

I was just thinking, is it possible to have my main query with all the data that needs filtering and counting and have my report do the filtering and counting? Rather than have my other 3 queries? Is this possible?

Cheers
Phill

PS just noticed the spelling in the header! Oops!

 

[boblarson]

Rather than have my other 3 queries? Is this possible?

Yes, it is possible.