Create customized format for detail field + Truncate characters

[mackinmn]

My subject line is asking two questions:

A particular field value is output to a report. An example of this value might be "01124134C" (no quotes). I would like to truncate the first 5 characters and format the remaining 4 characters so the above example would now appear as "13-4C" (again, no quotes)

I'll admit I'm relatively new to Access and am somewhat unfamiliar with the more advanced features. Any help or advice will be greatly appreciated.

John

 

[Databaseguy]

In the control source for the report, enter the following:

=MID([YourField],6,2)& "-" & RIGHT([YourField],2)

This assumes the data is always the same number of characters

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[JoeMiller]

If the field length is variable you can use this:

=MID([YourField],Len([YourField])-4,2)& "-" & RIGHT([YourField],2) Joe Miller
joe.miller@flotech.net