embedded hyperlink in access

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Any idea why this select won't run?

SELECT "<a href=""C:/Documents and
Settings/car9016/Desktop/POWPDS/"+dbo_vwPOWWebData.ProductC
ode+".pdf"">"+dbo_vwPOWWebData.ProductCode+"</a>" as
dbo_vwPOWWebData.ProductCode, dbo_vwPOWWebData.Technology,
dbo_vwPOWWebData.Box_Price,
dbo_vwPOWWebData.Distributor_Price,
dbo_vwPOWWebData.CureCurve, tblCodes.PDS, tblCodes.MSDS
FROM dbo_vwPOWWebData INNER JOIN tblCodes ON
dbo_vwPOWWebData.ProductCode = tblCodes.ProductCode;
 
Any idea why this select won't run?

SELECT "<a href=""C:/Documents and
Settings/car9016/Desktop/POWPDS/"+dbo_vwPOWWebData.ProductC
ode+".pdf"">"+dbo_vwPOWWebData.ProductCode+"</a>" as
dbo_vwPOWWebData.ProductCode, dbo_vwPOWWebData.Technology,
dbo_vwPOWWebData.Box_Price,
dbo_vwPOWWebData.Distributor_Price,
dbo_vwPOWWebData.CureCurve, tblCodes.PDS, tblCodes.MSDS
FROM dbo_vwPOWWebData INNER JOIN tblCodes ON
dbo_vwPOWWebData.ProductCode = tblCodes.ProductCode;
Click to expand...

Hi Pat,

You might try concatenating in subquery,
then join tblCodes to subquery.

SELECT
Q.PC,
Q.Technology,
Q.Box_Price,
Q.Distributor_Price,
Q.CureCurve,
tblCodes.PDS,
tblCodes.MSDS
FROM
tblCodes INNER JOIN
(SELECT
"<a href=""C:/Documents and Settings/car9016/Desktop/POWPDS/"
+ dbo_vwPOWWebData.ProductCode
+ ".pdf>"
+ dbo_vwPOWWebData.ProductCode
+ "</a>" as PC,
dbo_vwPOWWebData.Technology,
dbo_vwPOWWebData.Box_Price,
dbo_vwPOWWebData.Distributor_Price,
dbo_vwPOWWebData.CureCurve) As Q
ON tblCodes.ProductCode = Q.PC;

Please respond back if I have misunderstood.

Good luck,

Gary Walter
 
Back
Top