More than 4 formatting conditions-cross-tab report

I am really having difficulty with a solution to this problem. Not much SQL
experience. Any help/suggestions appreciated:
I have a report based on a cross-tab query that shows the percentage results
from different audits conducted at different departments (17 departments,8
audits) .

I have a background color if there are no results submitted, and then three
other colors based on high, medium, low results. I have used the conditional
formatting for this.

I now need to have a different background color if the audit was not
applicable to the department. There are two fields in the table that can be
used to determine if the audit was not applicable "NotApplicable" (Y/N) or
"AuditReceived" (date).

I don't know how to include these in the cross-tab query (I already have
where statements in the query for the date the audit was due). I also don't
know if I could use the select case function in the report to format the
background? And if so, how to write the code.

Thanks

What is your SQL Statement for the Cross-tab query?

You already mention that you have a background color for no results
submitted. I assume this means that [AuditReceived] is NULL.

Could you have a condition where the audit was applicable, but has not been
received? If so, would you want that to be a different color from the case
where it is not applicable?

It's been a while, but I believe you can setup more the 3 conditions, but
you have to do it via code. Doing a Google search on Access +VBA
+FormatConditions , I found the following
http://blogs.msdn.com/frice/archive/2004/06/08/151178.aspx), but there are
probable other examples.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"tg7" wrote:

> I am really having difficulty with a solution to this problem. Not much SQL
> experience. Any help/suggestions appreciated:
> I have a report based on a cross-tab query that shows the percentage results
> from different audits conducted at different departments (17 departments,8
> audits) .
>
> I have a background color if there are no results submitted, and then three
> other colors based on high, medium, low results. I have used the conditional
> formatting for this.
>
> I now need to have a different background color if the audit was not
> applicable to the department. There are two fields in the table that can be
> used to determine if the audit was not applicable "NotApplicable" (Y/N) or
> "AuditReceived" (date).
>
> I don't know how to include these in the cross-tab query (I already have
> where statements in the query for the date the audit was due). I also don't
> know if I could use the select case function in the report to format the
> background? And if so, how to write the code.
>
> Thanks