Report with conditionnal formatting issue

J

Julien W.

Hi everyone,

I have made a report based on a crosstab query (based on a table) which
looks like this:

------------------------------------------------------------------------------------
Head1 Head2 Head3 ...
Col1
subgroup1 Date1 Date2 Date3
subgroup2 Date4 Date5 Date6
subgroup3 Date7 Date8 Date9
...
Col2
subgroup1 Date1 Date2 Date3
subgroup2 Date4 Date5 Date6
subgroup3 Date7 Date8 Date9
...
Col3
...
------------------------------------------------------------------------------------

The crosstab query is based on a table which looks like this:

------------------------------------------------------------------------------------

[rec1] [rec2] [rec3] [rec4] [rec5]
---------------------------------------------------------------------------
Col1 Head1 subgroup1 Date1 percent1
Col2 Head3 subgroup3 Date2 percent2
Col3 Head12 subgroup4 Date3 percent3
Col4 Head7 subgroup4 Date4 percent4
.... ... ... ... ...

------------------------------------------------------------------------------------

My question is how to turn the "Date" fields to red (in the report) when the
percent value (column rec5 in in the table) is less than 100%?

The main issue is that the "percent" field is not a part of the report (and
does not have to appear OR be visible) and neither of the crosstab query.

Thank you for your help !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

union range 5
VBA for summing buys and sells 0
Data entry connected to daily date (over multiple months) 1
Changing three fileds with one action 3
Comparing Dates 9
Problem designing tables: Too many fields 20
Code to long - needs help on "if" statements 0
Using OWC.Chart control in asp 1

Top