Expression Builder

[Craig]

I have a filed called "status" and it can be A or I or P.

I want a report that looks like this:

Active Inactive Purge Name
A Joe
I Sue
A Bill
P Paul

So I need to have a label that shows in each column based on the contents of
"status"

In expression builder I have tried the following but I get an error:
=IIf([clientstatus]="A","A"," ") -- I put this under column Active
=IIf([clientstatus]="I","I"," ") -- I put this under column Inactive
=IIf([clientstatus]="P","P"," ") -- I put this under column purge

What am I doing wrong?

Thanks,
Craig

 

[HSalim]

You cannot use an expression builder to set the caption of the label.
Either use a textbox and make it look like your label - and use your formla
or use vba code to set the label's caption dynamically.

What's wrong with just presenting one column called status?
IF you want to display Active/Inactive/Purge add a combobox to your report -
it will behave just like a text box.

HS