I have a project list in access and I am trying to create a report that will list every project and have a link to its directory location (generated automagically). the directory is the project number so I pull together the prefix of the directory location and then the job number field in one of my tables in a query, then reference the query for my report. I then have set that text box to be a hyperlink in properties. When I export the report to my desktop as an html document all of the links point to my desktop folder.

Does anyone know how to fix this or perhaps offer a better solution.

Thanks,
JasonSelf

It would probably be better if you post the code or an example of what you are trying to acheive.