Querying multiple queries

[jon98548]

I have a union query I am using (for now) to combine several tables. If you would like some background on the setup, read this: http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=169358#post169358

I query this union for counting three items: Findings, Resolved Findings and Plans Submitted. I query it again for exclusions; made separate because this is a check box and only counts True. I query it again for Plans Accepted; made separate because this is a Yes/No field and only counts Yes. I would now like to be able to view these results on a form, but am unable to combine these queries together. What am I missing?

Structure:

qryCountMeasures
Division - Groupby
Findings - Count
Resolved - Count
Submitted - Count

This returns 2 records because I only have 2 Divisions with findings. Good to go.

qryCountExclusions
Division - Groupby
Exclude - Count (True)

This returns 2 records because I have 2 divisions each having an exclusion. Good to go.

qryCountAccepted
Division - Groupby
Accepted - Count (Yes)

This returns 1 record because only 1 division has a plan accepted. Good to go.

Trying to bring this together has made my right eye red, my left temple hurt and my nose itch. Thanks.

 

[Pat Hartman]

Use a main form with three subforms.