Report Query Conundrum

[Anne8580]

I have 4 circuits that I record outages for in a single table. Every week a
report is created that lists the activity for each circuit. If there is no
outage, I want the report to say 'none' for the times of the outage, 0 for
the minutes out, 0 for the total # of outages, and 100% availability. The
query I run only gives me results when there is an outage on a circuit. How
do I get this information to appear in a report? Is this a problem with the
query or the report? I am running 2 queries to produce this information, so
I am doing a subreport within a report.

 

[Klatuu]

Although it is usually best, from a performance perspective, to do
calculations in the report rather than in the query; however, in this case,
it needs to be in the query. The report cannot "fill in the blanks". If
what you mean is that not outages for this week, you will have to get
inventive with writing a query that can fill in missing weeks in the data or
it may be necessary to do some recordset processing with a temporary table.