If ToText({customer,CUSTOMER ID}) [1] = "6" Then
Click Check to test for errors. You will receive the following error message:
This field name is not known.
Click Print Preview on the Standard toolbar to check the values in the report and compare the fields to see if the field values returned by @Formula2 are correct.
You should see "TRUE" next to all customer numbers that begin with 6 and "FALSE" next to all customer numbers that do not begin with 6.
Go on to Formula3.
| Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |