HELP Take out numbers from scan

  • Thread starter Thread starter Lost
  • Start date Start date
L

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
 
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.
 
Back
Top