A2007 Hyperlink

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

A2007 allows multiple hyperlinks in a single column. I want to update a
hyperlink column with some additional hyperlinks. The column may or may not
be null. It may have a hyperlink in it I want to add to .

What's the process? I know how to do an update query, I just don't know how
to structure the column. Do I just use the ampersand operator and update the
column that way, or do I need to place a separator between hyperlinks?
 
While I generally agree with you that I wouldn't normally use a multivariate
capability, I think this is a reasonable exception. I see no time when I'd
want to search the column, and I do see that multiples make sense. MS has
made it quite easy to do, at least manually.

I could make it a "child" table, but I'm not sure it's worth the trouble.
 
I've reconsidered. It wasn't as easy as I thought, and it's not that hard to
have a secondary table. The secondary table could even save disk space. Thanks
 
Back
Top