Access 97 How to Define the Field Type with a create table query to be Hyperlink
Posted on 2003-11-25
I am using a make table query to create a list of hyperlinks to files stored on a remote server.
When I run this query it creates the new table, but the new field is of the type text.
How do I get the Query to create this new table but have the field type as a hyperlink instead of just text?
I have a record type called STOCKNO
STOCKNO is a text field similar to the following:
I am extracting the first two characters and then only the numeric portion of this field DK12345 and creating a link to a word documet in the form of
I would like this to then be stored in a new table as a hyperlink.
here is the Expression I am using...
link: "j:\sales\quotes\writeups\" & Left$([STOCKNO],2) & Val(Right$(Trim$([STOCKNO]),Len(Trim$([STOCKNO]))-InStr(Trim$([STOCKNO]),"-"))) & ".doc"
this creates a new field called link in the new table
This works as expected, but when the new table is created the field is of the type text.
where or how do I get the query to create a field of the type Hyperlink instead?