Alterning display of numbers in report

M

Margy

I want to have a field in a report do something like ...

If the number starts with "99" then chop off the first two digits.

Can someone help me with this function?

I've tried:
If ([Field1]=99###, LTrim ([Field1], 2), [Field 1])
but it does not work. Help please!
 
J

John Spencer

Is the field a text field or a number field. The following will probably
work in either case, but it will turn a number into a string containing
numeric characters.

IIF (Left(Field1,2)="99",Mid(Field1,3),Field1)
 
F

fredg

I want to have a field in a report do something like ...

If the number starts with "99" then chop off the first two digits.

Can someone help me with this function?

I've tried:
If ([Field1]=99###, LTrim ([Field1], 2), [Field 1])
but it does not work. Help please!
Click to expand...

As control source in an Unbound control on the report:
=IIf(Left([FieldName],2) = "99",Mid([FieldName],3),[FieldName])
 
Top