>- see footer for list info -<
Hello,
We've got this expression in CFR which is fine...
IIf((InvoiceWOPO.mediatypeID is 59), DE("Pack Item Title"), DE("Media
Owner"))
...but we want to expand on it so we can add another clause to it...
* 89 = Literature...
I was thinking we could do an excel style nested If... like this but it
doesn't appear to be working:
IIf((InvoiceWOPO.mediatypeID is 59), DE("Pack Item Title"),
IIf((InvoiceWOPO.mediatypeID is 89), DE("Literature"), DE("Media Owner")))
Does anyone know if we can do what we're after?
Thanks in adance!...
Nick
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<