Advanced Report Conditional Format

[MrHoliday]

Dear Access Friend.



I need some advices and would be happy for any tip you may have to help me out.

Problem Report Conditional Formating , I looking for help on "advanced" not the "basic" formating options

Example - Description of the situation

Imagine a table with 2 columns

Column A = CAR BRAND
Column B = COUNTRY

The result report is grouped per Column A "CAR BRAND"


CAR BRAND

bmw

COUNTRY

Germany
Germany
Italy
Germany
France
Germany

CAR BRAND

ferrari

COUNTRY

Italy
Italy
Italy
HongKong
Italy
Italy

So, what I am looking for is that the "COUNTRY" falling out of the "normal" or "most used country names", is highlighted in Red and this on Group level, not on the complete report level.

Is their a possiblily to do such thing?


Thanks in advance for any answer.

Jerry

[NTC]

You would do the work before it gets to the report. Count the countries per country per group. Apply your alogorithm as to "normal" or not. And then assign a code to each. All this using queries.

Then in report the basic conditional formatting would be based on that code that is in the underlying record set.

[MrHoliday]

Thanks, I will look into this possibilty