Rabu, 12 Agustus 2015

[MS_AccessPros] iif statement on a query

 

Pros,  I need to use the same field various ways depending on the value of another field.

 

I’m trying this:  MaterialCost: IIf([IECOST]="A1",[LocalF30026]![ICESL],0)

 

Where [LocalF30026]![ICESL] is a valid field, but it is prompting me like it is a parameter.

 

Can’t I do this?

 

If not, how do I do this?

 

Thanks.

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.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