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