(newbie) Combining records into hyperlinks, how?

  • Thread starter Thread starter Henrik C. L.
  • Start date Start date
H

Henrik C. L.

Hello dear fellows,

I want to combine data from two tables into hyperlinks.

In the first table there is a field of data type Text, such as:
Field1:
qwe.com
asd.com
etc.

In the second table, the first field has machine names and the second field
looks up entries from the previous table, such as:
Field1: Field2:
mother qwe.com
father qwe.com
mother asd.com
sister asd.com
etc.

My question is if Access can combine those fields into new hyperlinks for me
(for example in a query or perhaps in the same table), such as:
http://mother.qwe.com
http://father.qwe.com
http://mother.asd.com
http://sister.asd.com
etc.

Is this possible? How? This is way too complicated for a newbie as myself.
Please help.
 
Back
Top