My database tool tracks performance audits on a growing list of [Safety
Standard]s. As the list of safety standards is growing, the reports are
becoming unmanageable. The crosstab query below is the record source for one
of the reports I generate each week.
TRANSFORM Avg(Dqry.Percentage) AS AvgOfPercentage
SELECT Dqry.[Safety Standard]
FROM Dqry
WHERE (((Format([Date Of Audit],"ww")) Is Not Null)) OR (((Dqry.[Safety
Standard]) Is Not Null)) OR (((Format([Date Of Audit],"ww")) Is Not Null))
GROUP BY Dqry.[Safety Standard]
ORDER BY Format([Date Of Audit],"ww")
PIVOT Format([Date Of Audit],"ww") In
(32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52);
I would like to preserve the weekly results but in the report rather than
listing every standard the way it does now I would like only the standards
that have been audited to show.
Is there a way, with say conditional formatting in the report, to show only
those Safety Standards that have been audited in week 41 while preserving the
accumulated percentages for the previous weeks? If not with conditional
formatting is there another way? Thanks for your help.
--
Jeff C
Live Well .. Be Happy In All You Do
|
Similar Threads
