Can a query field display as datatype hyperlink?

[r.f.miller]

Is it possible to display a field constructed from text concatenated from
other fields and have it displayed as datatype Hyperlink?
I want to create a query that builds a hyperlink in a field on the fly for
export that creates a static web page with these built hyperlinks. I could
build a new text field and then convert this field to hyperlink, but thought
there might be a more direct way to just define the query built field as
hyperlink. Thanks.

 

[Allen Browne]

Queries are not really meant to be the interface in Access. Create a form
(in datasheet view if you want it to look like a query.) You can then show
the calculated field as a hyperlink by setting the properties of the text
box.

Be sure the include the 2 # characters in the field when you can concatenate
the values together.