Hi all,

SOS.....

I have two queries with the same fields. These fields are [CatID] and 
[EquipID]. The queries are Qry1 and Qry2. Qry1 retrieves records in my 
MasterTable and Qry2 retrieves records from my UseTable.

I have two reports to generate results and grouped by [CatID]. I have a 
text box to Count the number of [CatID] found in each group.

My Report1 will give the following:

No.   CatID   Count (Available)
1.    ABC01   2
2.    DEF01   4

My Report2 will give the following:

No.   CatID   Count (Not Available)
1.    ABC01   1
2.    DEF01   3

QUESTION:
I wish combine both the output into one report. So that I can have a 
report to see the status. Something like this:

No.   CatID   Available   Not Available
1.    ABC01   2           1                
2.    DEF01   4           3            

Your assistance is very much appreciated.

Thanks,
Maha

You could just create a query using your two queries and join both the 
fields then run the report off this new query.  This will just get records 
in both queries.  If you need all records from both queries; in your new 
query design view, right click on the join and change the setting to have 
all records from both queries in.  

Hope this works,

Regards, Phillip

> Hi all,

> SOS.....

> I have two queries with the same fields. These fields are [CatID] and 
[> EquipID]. The queries are Qry1 and Qry2. Qry1 retrieves records in my 
M> asterTable and Qry2 retrieves records from my UseTable.

> I have two reports to generate results and grouped by [CatID]. I have a 
t> ext box to Count the number of [CatID] found in each group.

> My Report1 will give the following:

> No.   CatID   Count (Available)
1> .    ABC01   2
2> .    DEF01   4

> My Report2 will give the following:

> No.   CatID   Count (Not Available)
1> .    ABC01   1
2> .    DEF01   3

> QUESTION:
I>  wish combine both the output into one report. So that I can have a 
r> eport to see the status. Something like this:

> No.   CatID   Available   Not Available
1> .    ABC01   2           1                
2> .    DEF01   4           3            

> Your assistance is very much appreciated.

> Thanks,
M> aha