print field as hyperlink in report

M

M B

Hi:

I'm working on an online book catalog which will hold records for print and
electronic books. In the report, I would like the titles for the electronic
books to show up as a hyperlink so that the users can access the book.

Mostly because I'm new to Access and wanted to explore its functionality, I
used conditional formatting to format the text look like a hyperlink
([Format]="electronic"), but how do I insert <A HREF=" "[Title]> and
have it come out in the report?

I have one table called Books with [BookID], [Title], and [Format] and
another table called Hyperlink with [BookID] and [URL].

Any help would be appreciated!

Thanks,

Margaret
 
Top