I am trying to use the data in a particular field (the value) as Part of a hyperlink

Example

Field name is "Drawing" in a table called "Orders"

Field value is 12345

I want to open a link to "http://intranet/onlineapps/Dwg/SrchItem.php?CS ItemNo=12345" where the entire link will be the same for each record, with the exception of the last numbers which will be...