HELP Take out numbers from scan

[Lost]

I have a sub form that has three cel.

Cel #1 Package ID
Cel #2 Carriers: UPS, Fedex, Fedex Ground, DHL
Cel#3 Tracking Numbers

What I need help on is that UPS, Fedex Ground, DHl scans perefectly but
Fedex tracking has to many digits that are not needed. I need away when
fedex is picked the first 16 numbers are removed and the last four are
removed.

If anybody has a id i would be greately appreciated.

Thank You

 

[Tom van Stiphout]

On Wed, 23 Apr 2008 13:20:00 -0700, Lost

If you're doing this in a query, the IIf function may help. Something
like:
select PackageID, Carrier,
IIf(Carrier='Fedex',mid$(TrackingNumber,17,len(TrackingNumber)-16-4),TrackingNumber)

(of course I guessed your column names)

-Tom.