Hyperlink Syntax

[mattc66 via AccessMonster.com]

I am trying to add the hyperlink in my query. Its a combination file path and
the file name is made up of 2 records. FKQuoteID and Revision followed by the
file type - dwf.

Can some one help me with the syntax.

FileLocation: "W:\ROOMS Daily Drawings\DWF\&""&[FKQuoteID]&""&[Revision]&.
dwf"

Thanks

 

[Guest]

I think you need the quotes before the ampersands:
FileLocation: "W:\ROOMS Daily Drawings\DWF\" & [FKQuoteID] & [Revision]&".dwf"

 

[mattc66 via AccessMonster.com]

That added the correct file path name, but how would I make it into a
hyperlink in the query?

I think you need the quotes before the ampersands:
FileLocation: "W:\ROOMS Daily Drawings\DWF\" & [FKQuoteID] & [Revision]&".dwf"

I am trying to add the hyperlink in my query. Its a combination file path and
the file name is made up of 2 records. FKQuoteID and Revision followed by the

[quoted text clipped - 6 lines]

Thanks