There's also the Switch function:
=Switch([Type]="W", "Warehouse", [Type]="C", "Cutter", [Type]="V", "Vendor)
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
If you don't want to do this the proper way ;-) then you can use this less wordy solution:
=Choose(Instr(1,"WCV",[Type])+1,"Other","Warehouse","Cutter","Vendor")
Duane Hookom, MVP
MS Access
To:
MS_Access_Professionals@yahoogroups.comFrom:
MS_Access_Professionals@yahoogroups.comDate: Tue, 29 Dec 2015 17:30:03 -0800
Subject: Re: [MS_AccessPros] Is there a more 'elegant' way todo this
I think I'll leave it for now, with 4 choices it's not so bad.
Thanks
Sarah
---In
MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
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
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
Tidak ada komentar:
Posting Komentar