Reports

I have created an access database that is used to record machine failures.
Typically a failure will happen anything from twice per day to a couple of
times per month.

I also created a query that adds up all of the downtime and a report that
uses this query, the report shows a barchart of downtime against maximum
availability but only for the weeks that there has been an entry.

Can anyone give me any pointers on how to change the report or query to show
the weeks that have no downtime.

Thanks in advance

Re: Reports

On 21 Jan, 15:42, "}{" wrote:
> I have created an access database that is used to record machine failures.
> Typically a failure will happen anything from twice per day to a couple of
> times per month.
>
> I also created a query that adds up all of the downtime and a report that
> uses this query, the report shows a barchart of downtime against maximum
> availability but only for the weeks that there has been an entry.
>
> Can anyone give me any pointers on how to change the report or query to show
> the weeks that have no downtime.
>
> Thanks in advance

I resolved a similar problem recently by creating a second query
containing one entry for each period that needs to be reported and
then creating a union query to combine the second query and the
original data-driven query. The report can then be driven from the
union query.

The underlying priciple is that you have to have something in the
query that drives the report for each period that you want reported.

Regards, Tony.