Using Two Queries on One Report

[cdogstu99]

I have one table called "Funds" which lists an extensive list of mutual funds and each is categorized by a particular asset class (ie Large Growth, Small Growth, etc). I have two queries; one which counts each of the products via the asset class, and another which counts via asset class if a certain field is checked. I need to produce a report which lists the counts via asset class and the associated count for the second query. But, when i start a report i am able to list the count from the 1st query, but unsure how to get the data from the second one.

Any help would be greatly appreciated.

Thanks!

 

[pbaldy]

Sounds like a job for a subreport.

 

[cdogstu99]

Ok..well i uploaded an excel sheet which is the way i need the data to look. Should i create a report with one query and then put subreport in the original report????

 

[pbaldy]

Actually that probably isn't a situation for a subreport. What does the data look like (the table structure)? Can you post a sample db?

 

[cdogstu99]

ok here's db with sample table........the queries aren't in the db, but esentially, query 1 is just counting each record by asset_class (which are existing --under existing_prospect), and query 2 is counting the same but those which have Alt_Identified as "No".

P--thanks for looking at this for me..i appreciate it...

---Chris

 

[pbaldy]

All right, run qryPaul and see if it's on the right track.

 

[cdogstu99]

Paul....you're the man!!!!!

I have no idea what you did, but that is perfect!...Thanks so much!!

 

[cchaalan]

Counting records in multiple table in one query

Hi,
I used the info in the previous record to count the # OF RECORDS in one table in my query. Is there anyway, to count other table records in the same SQL Query?
This counts the total records for table 1:
SELECT Count(*) AS TNAME1 FROM T_name1;
Please help & Thank you in advance.
cchaalan

 

[pbaldy]

cdogstu99: glad to help!

cchaalan: I assume your post was in error, since I also see it elsewhere and it doesn't seem to relate to this thread.

 

[cdogstu99]

Paul, one last question on this. In trying to build the report, the query is stretching across two pages. Can you tell me how to continue the data on the one page and have it flow underneath the top line of the page?