Avatar of bergen69
bergen69

asked on 

Is this VBA? What does it say:

Iif(TRIM((ActiveFieldValue("COMPANY")))="ALB"and TRIM((ActiveFieldValue("UMB_RATE_AREA2")))= "Lousiana" or TRIM((ActiveFieldValue("COMPANY")))="ALB"and TRIM((ActiveFieldValue("UMB_RATE_AREA2")))= "Guam" or TRIM((ActiveFieldValue("COMPANY")))="ALB"and TRIM((ActiveFieldValue("UMB_RATE_AREA2")))= "District of Columbia","", (TRIM(ActiveFieldValue("UMB_RATE_AREA2"))))
Programming Languages-OtherScripting Languages

Avatar of undefined
Last Comment
Randy Downs
Avatar of yobri
yobri
Flag of United States of America image

Since the condition is IIF, it appears to be an Access formula to remove spaces (on either side) based on the If conditions specified in the formula above. I typically see these IIF statements used during an Access Query.
ASKER CERTIFIED SOLUTION
Avatar of Randy Downs
Randy Downs
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Scripting Languages
Scripting Languages

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

30K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo