Multiple IIfs

[SueO]

In my report I want to leave certain information out. The query name is 'qryAGRESSOSubProjectCodes', the field name is 'CostCentre' and the report name is 'rptAGRESSOSubProjectCodes'. In the field 'CostCentre' I want a blank ("") return if the CostCentre = "500 685 101" also if it = "500 686 101" and also if it = "500 688 101". All the others I want to see. I think I am making a mess of using IIf, so if there is anyone who can help I will be eternally grateful. Many thanks.

[maximus]

In the query u need to cReate a calculative Field called CostCenter1 with the following Expression:

iif([CostCentre]="500 685 101" Or [CostCentre]="500 686 101" Or [CostCentre]="500 688 101","",[CostCentre])