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
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