Access XP Expressions

L

Lachelle

Hello-
I am trying to create a form for my companies invoices. I know how to build
a simple expression using 1 field in the expression, but how do you build an
expression using multiple fields?
For example: Amount A = [Current Invoice amt]*.51 - This is the simple
expression
but if I want to add to that expression something like the following, how
would I do this?
Amount A = [Current Invoice amt]*.51 if Split = 3
I think I need to know the expression for "if"

Thanks
LaChelle
 
B

Brendan Reynolds

There is an IIf (Immediate If) function. It takes three arguments, the
condition to be tested, the result to return if the condition evaluates to
True, and the condition to return if the condition evaluates to False. For
example ...

=IIf(Split = 3, CurrentInvoiceAmt * .51, CurrentInvoiceAmt)

.... would display the result of multiplying CurrentInvoiceAmt * .51 if Split
= 3, or the value of CurrentInvoiceAmt if Split is anything other than 3.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top