I
Ivor Williams
I'm tracking jobs using job numbers with different prefixes depending on the
type of job. Examples are P6666, PE5555, S4444, SEQ7777, etc. The type of
job has tax implications, so depending on the alpha prefix, I want to write
a function which calculates the tax. For example, if the prefix is a PE, I
want to have tax calculated, if the prefix is an S, I want to tax amount to
be zero. I've tried using IIf ([JobNo]="PE*", ([Cost]*.07), IIf
([JobNo]="S*","0") and various different combinations of it with no luck. I
don't think it likes the asterisk. Nor does it seem to like my syntax. I'd
really appreciate some help.
Ivor
type of job. Examples are P6666, PE5555, S4444, SEQ7777, etc. The type of
job has tax implications, so depending on the alpha prefix, I want to write
a function which calculates the tax. For example, if the prefix is a PE, I
want to have tax calculated, if the prefix is an S, I want to tax amount to
be zero. I've tried using IIf ([JobNo]="PE*", ([Cost]*.07), IIf
([JobNo]="S*","0") and various different combinations of it with no luck. I
don't think it likes the asterisk. Nor does it seem to like my syntax. I'd
really appreciate some help.
Ivor