A simple question

[DenizBerkel]

Hi,
I have a very simple access database to ask you guys how to do this:
I want my Rating Field to be Green when Criteria is A
Amber when Criteria is chosen B
Red when Criteria is chosen C
Purple when Criteria is D.

I have attached my database as well.
Thank you very much...
Deniz

 

[JHB]

You can't do that on the table level, (tables are only for storing data).
Create a form, (use a query to get data from the table) and use "Conditional Formatting" to provide what you are asking.

 

[DenizBerkel]

Thank you for your reply. I have already done what you suggested. Form/Query/Conditional formatting.
But with the conditional formatting I realize that you can only color the field that you are on.
What I want isthat when Criteria field is chosen as A then I want the Rating field to be Green. (or at least it can be just written as Green instead of being green colored).
I think I need to use IIF statement in the query expression builder.
I wrote
RAGRating:IIf([Criteria]="A","Green",IIf([Criteria]="B","Amber",IIf([Criteria]="C","Red",IIf([Criteria]="D","Purple","Other"))))

but when I press Run button a parameter asking box appears. So I don't know what I'm doing wrong...

 

[DenizBerkel]

I found my mistake ...I wrote criteri instead of criteria for the color Amber...
Thank you for your time...