Re: Multiple Queries Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

angelinarose via AccessMonster.com wrote:
I have a database to track awards for our program. I have created several
queries and reports however I want to do a all inclusive status report for
the Awards program.

I have made Queries for Pending Awards for the Current Week, Previous Week,
Previous Month, Current Month, Previous Qrter, Current Qrter, Current YTD,
Previous Year. I also have Queries for presented Awards for Current and
Previous: Week, Month, Quarter, Year

I have a question that I am stumped on. The several queries that I have made
I want to place into one report. In some cases one of these queries may have
blank data. If the query returns blank data I want to place something into
the field that says "No Data Found". I have attempted to combined all these
queries together into one query and however when I run the query It returns
nothing just the field names even thought I know some of the queries do have
data in them. How can I complish this? or is it even possible? I know I have
tried doing subreports but if even the field name show up in the subreport
when I place it into the report it ends up not showing up.


Why you are not getting any records from your combined query
depends on your query's design. How the query's data is
supposed to be displayed in the report.

Using subreports may not be necessary, but it should be
pretty straightforward. I think you said you have all this
working except for displaying a No Data message. That part
is quite easy my adding a text box on top of the sunreport
control. Set the text box's and its section's CanShrink
property to Yes and use an expression like:

=IIf(subreportcontrol.Report.HasData, Null, "No Data Found")

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Same Parameters in all sub reports
    ... something wrong between the form and the query. ... It didn't for my regular queries. ... "Jeff Boyce" wrote: ... Build a query that will be used to provide data to your report. ...
    (microsoft.public.access.reports)
  • Re: Queries are driving me nuts!
    ... Then tell us how you want your queries and/or reports to appear. ... >>> name the report was totally blank. ... I then ran each query separately to ... >>> taught every lesson yet. ...
    (microsoft.public.access.queries)
  • saved queries based on other saved queries vs. one big query in a forms module using DAO
    ... domain aggregate functions to do what you want to do, ... rather than having nested queries. ... Calculating the summary values in the query has some ... calculating the values in the report ...
    (microsoft.public.access.queries)
  • Re: Help with query
    ... such as the definitions of the Queries you refer to, and sample records from the Tables. ... In addition to the sample records I mentioned in each of the Tables used by your Queries, I suggest that you also show an example datasheet that shows the results you'd like your Query to display, based on those sample records. ... I currently have a statement report that has a subreport of all linked to the ... the enterprise rules are payment 30 days from end of month.... ...
    (microsoft.public.access.queries)
  • RE: More line number questions
    ... "Barry" wrote: ... When we linked the original 2 queries and added all the records from ... mimic the old paper report, ... Yes indeed I did change the link in the query to a Left Join. ...
    (microsoft.public.access.reports)