I need to form a sql 2005 database field into a URL that takes users to a page in an online legislative journal. Let me try to explain: The field in my db is an int field that contains the journal page number. Below is the form script from the public legislative site that takes users to a journal based on the page number provided by the user. The link is to a pdf version of the journal document for the entire day, and although users enter a specific page, the link simply opens the journal for the day that contains that page number.
I guess what I need is a URL field that replicates the output of the form below. Hope this makes sense. Thanks.