Alterning display of numbers in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)
 
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])
 
Back
Top