A
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
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