If Then statements

[Joseph]

How would one make a expression that can perform two
different addition operations to fill a field depending
on the value of a number found in an earlier string? For
instance, if the number is between 1 and 3 add 10, and if
the number is between 5 and 9 add 20. So what would the
expression look like and how could it be implemented to
automatically fill the field?

 

[Jeff Boyce]

Joseph

It sounds like you are trying to store a value in a table, based on a
"calculation" (If ... Then...). Unless there's a pressing business need,
don't store calculated values.

Instead, use a query to generate the values (RAM works faster than
HardDrive).

If there is a pressing business need to store, be aware that you'll also
need to work out the routines to keep all pieces synchronized, in case any
one of them changes.