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

 

I would create a small lookup table and include it in the report's record source query. When there are more than 4 options, maintain your table rather than an expression. 

IMO, this is the only solution ;-)

Duane

Sent from Outlook Mobile

On Tue, Dec 29, 2015 at 4:14 PM -0800, "sarahk@schemesoftware.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

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: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___