Expression Builder

[starclassic]

I need help on expression builder on the report.
Needs to reformat the output for policy number when opening the "credit" report.
the field strPolicy on table is showing like this 601234567
Output on report if strCompany = "A" then
strPolicy = 1234567-60 Else
strPolicy 60-1234567.
I'm not familiar with Expression builder. any help would be great

 

[Remou]

Depending on what you hope to do, this may suit:

[tt]IIf(strCompany = "A", Mid(strPolicy, 3) & "-" & Left(strPolicy, 2), Format(strPolicy, "##-#######"))[/tt]