Use fields in table as part of hyperlink

[d.christopher.stewart]

Hello,

I want to include a hyperlink in a report based off of two fields in a
table. Essentially I want to dynamically build the URL such as:

http://www.abc.com/group/[TABLE1].[FIELD1]&[TABLE1].[FIELD2]/post.php

I've searched high and low and can not find this capability in Access.

Thanks for any help on this!
-Chris

 

[Allen Browne]

That should work. You may want to add the # around the actual address, i.e.
use:

http://www.abc.com/group/[TABLE1].[...[TABLE1].[FIELD1]&[TABLE1].[FIELD2]/post.php#