Adding a literal to a report

[Cobra7]

I have a report as follows:

Select tblComputerSystemProduct.Name, tblComputers.Computername, tblComputers.Lastseen, tblComputers.Username, tblComputerSystemProduct.IdentifyingNumber From tblComputers Inner Join tblComputerSystemProduct On (tblComputers.Computername = tblComputerSystemProduct.Computername) Where tblComputerSystemProduct.Name = 'OptiPlex 745'

Works great. My manager would like to turn the IdentifyingNumber into a support link like the action page of the web site, any way to do easily that?

[Hemoco]

Try this :

Select tblComputerSystemProduct.Name, tblComputers.Computername, tblComputers.Lastseen, tblComputers.Username, <a href="http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?ServiceTag=' + tblComputerSystemProduct.IdentifyingNumber + '">Support link</a>' as link From tblComputers Inner Join tblComputerSystemProduct On (tblComputers.Computername = tblComputerSystemProduct.Computername) Where tblComputerSystemProduct.Name = 'OptiPlex 745'

[Cobra7]

Sorry, I must be doing something wrong.

Select tblComputerSystemProduct.Name, tblComputers.Computername, tblComputers.Lastseen, tblComputers.Username, <a href="http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?ServiceTag=' + tblComputerSystemProduct.IdentifyingNumber + '">Support link</a> From tblComputers Inner Join tblComputerSystemProduct On (tblComputers.Computername = tblComputerSystemProduct.Computername) Where tblComputerSystemProduct.Name = 'OptiPlex 745'

[Hemoco]

You can inject the sql directly into the query:

... ,'<a href="http://somesite.html?id=' + tblComputerSystemProduct.IdentifyingNumber + '">linktext</a>' as link from ....