Multiple Queries Question

[angelinarose via AccessMonster.com]

Hi All,

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. I'm fairly new to
access so any help would be greatly appreciated!

Thank you all in advance

 

[Marshall Barton]

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")