Reporting from multiple queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have a report from one query and it works fine, however in this report I need in the report footer a "Count" field from another query. Is this possible, and if so how do I do it? Thanks...
 
Hi,

Yes it is possible (if I'm understanding your question correctly). Example:

- Report based on query "Query1"

- In the Report Footer have 2 textbox controls with the following for their
control sources

= DCount("[field1]", "[Query2]")

= DCount("[field1]", "[Query2]", "[field2] = 'Some
Value' ")

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| Thread-Topic: Reporting from multiple queries
| thread-index: AcPvI9NeBUwlijJOSvirVMhSMQ3olQ==
| X-Tomcat-NG: microsoft.public.access.reports
| From: "=?Utf-8?B?TWlrZSBDLg==?=" <[email protected]>
| Subject: Reporting from multiple queries
| Date: Mon, 9 Feb 2004 07:46:04 -0800
| Lines: 2
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.reports:130175
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.reports
|
| Hello,
I have a report from one query and it works fine, however in this report I
need in the report footer a "Count" field from another query. Is this
possible, and if so how do I do it? Thanks...
|
 
If the "another query" contains only one record, you can just add it to the
recordsource of your report and don't add any join lines. Make sure you add
the appropriate field to the query grid.

--
Duane Hookom
MS Access MVP


Mike C. said:
Hello,
I have a report from one query and it works fine, however in this report I
Click to expand...
need in the report footer a "Count" field from another query. Is this
possible, and if so how do I do it? Thanks...
 
Back
Top