UPS-FEDEX Tracking Number - clickable

[Anonymous]

 I have a table that contains shipment records.  It contains a UPS or Fedex tracking number.  I know that field can launch a URL but in my case I need to concatenate the tracking ID with URL:

The field contains: 1ZRV22390344023950

And the URL for UPS would be: 

http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=1ZRV22390344023950

Any help is appreciated.

[Visshal]

You must try this ups tracking page. You can put your tracking number  to the tail likr this 

https://trackingi.com/ups/id-1ZRV22390344023950

You must replace your id 

[Greg_Deckler · Accepted solution]

@Anonymous - You should be able to create a new column like this:

New Column = "http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=" & [Column]

Here [Column] is the name of the column that has your tracking id in it.