MS access 2010+ report with hyperlink creation issues
trying to create an access report which is output as HTML which contains a list of dates and reports for the user can select from. The report is driven by a DB query which contains a field with the date, a field with the report title and a field which has a url to the report. I'm trying to create a hyperlink that displays the report title field as a link and uses the other field as the actual link address. Can't seem to put the 2 fields together.
PatHartman
The hyperlink is one of those abomination data types that require specialized SQL since there are actually two fields involved.. If you change the table to contain two columns instead of one, you will find them easier to use. Plus should you ever have a need to upsize to SQL Server, you won't be thwarted by having a non-compatible data type. I don't have the specific SQL you need since I don't use the Hyperlink data type but at least you now know what you are looking for if you elect to stick with the hyperlink data type.
ASKER
Pat: not sure I understand ur comment, but I have 2 separate input fields. One field has the text I want to display and the other has the url to the actual report. All I want to do is is have a hyperlink field that displays the text from one field and uses the when the link is clicked.
That's what the hyperlink data type does. In your table, is there one field defined as hyperlink or two fields. One to hold the path or URL to the file you want to open and the other to contain the display value?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Answer provided.