Selasa, 29 Desember 2015

[MS_AccessPros] Is there a more 'elegant' way todo this

 

I am populating a text box on a report as follows:


=IIf([Type]="W","Warehouse",IIf([Type]="C","Cutter",IIf([Type]="V","Vendor","Other")))


The Type field can have 4 different values: W,C,V,O.


I use a value list in my form, but for the report I used the IIF statement. 


I have a feeling there is a 'better' way to do this, but I could not figure it out.



Thanks


Sarah



__._,_.___

Posted by: sarahk@schemesoftware.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar