Displaying combo box values (Assets instead of A)

[peters]

I am currently tyring to develop what has turned out to be a very difficult report.

One little problem I am having is as follows:

I have one field which is defined through a combo box which gets its values from a separate table (examble A = assets, L = Liabilites, R= Revenue). Of course the A, L and R is what is stored.

When I include this filed in my report I only see the stored value (A, L, R).

Is there a way I can make it display (for example) Assets instead of just A in my report.

Thanks.

 

[Rich@ITTC]

Hi Peters

Let's say you field is called "Status".

In the Control Source row in properties for that field on your report you could use a nested immediate if expression (IIf).

=IIf([Status]="A","Assets",IIf([Status]="L", "Liabilities","Revenue"))

HTH

Rich Gorvin

 

[peters]

Thanks Rich@ITTC. Worked like a charm. I very much appreciate it.

I have been trying to figure out this problem for almost a week now. I had tried differen versions of "if" statmenets but couldn't get them to work. Now I know why.

Thanks again.

 

[peters]

Thanks Rich@ITTC. Worked like a charm. I very much appreciate it.

I have been trying to figure out this problem for almost a week now. I had tried differen versions of "if" statmenets but couldn't get them to work. Now I know why.

Thanks again.