Conditional depended textbox value change if not null

Manos39

Registered User.
Local time
Today, 06:08
Joined
Feb 14, 2011
Messages
248
i need help please,

i use a report to display values depending on work type of employees for every day of each month like 1,2,3,..31
The query suporting that report is crosstab query and the values displayed in the report is "ΧΡ ΚΥΡΙΑΚΗΣ"
or "NYXTA" or ""ΧΡ ΚΥΡΙΑΚΗΣ" or "ΑΡΓΙΑ".
I need to have the report replace all the values to "8" but problem is that i cannot do it in the query, because
values like "ΧΡ ΚΥΡΙΑΚΗΣ" etc, are used with conditional formatting in the same report to change forecolor as needed.
How could i change the values to "8" and not harm conditional formatting? with code? conditional formatting expression?

please give me a little help on that
 

Users who are viewing this thread

Back
Top Bottom