Using Different Queries Same Report

[jadefury]

I have multiple queries let's call them A, B, C, and D. I want that data all on one report. I had tried doing subreports, but that seems very complicated. Is there a way to point the control source to the specific data? I was trying to use
=Abs(Count([rejected1 Query]![Case Disposition:])) however access can't find the control source. Thanks in advance!

 

[pbaldy]

No, that won't work, as you can't refer to a query that way. The nearest equivalent would be a DCount() function. Depending on the relationships between them, other options include a single query that joins them together, a UNION query, or the subreports.

 

[MSAccessRookie]

I have multiple queries let's call them A, B, C, and D. I want that data all on one report. I had tried doing subreports, but that seems very complicated. Is there a way to point the control source to the specific data? I was trying to use
=Abs(Count([rejected1 Query]![Case Disposition:])) however access can't find the control source. Thanks in advance!

Have you tried something like:

=SELECT Abs([Case Disposition]) FROM [rejected1 Query]