I have a report in access that displays some help desk tickets. I would like to click a link in that report that will take me to that ticket on a webpage. I want the link to refer to that specific ticket. So the format is http://server/tickets/id
I would like a link that fills in the id for me. I have that id in my database as tickets.id. I can display the ID on the report but can not make it clickable to the correct ticket. I was hoping I could do something like http://server/tickets/
[tickets.id] but no luck. The hyperlink builder does not seem to have this option. Is there a way for me to use tickets.id in the paths setting on the hyperlink builder?
or any other options?