merge two field in query but keep hyperlink format

[ali_sh]

Hello
I have two field containing Folder Name and File Name and I want to merge them in one field.
Also I created a field ("LinkFiled") to create link into that and changed field format to hyperlink.
I created a query and wrote below code in field row of query in one column but when executed query, hyperlink format disappeared.

LinkFiled: FileName & "#" & FolderName & "\" FileName & ".png#"

Is there any other way to do that by writing this code in another place or using sql or ... ?
thanks in advance

[ranman256]

Don't use #, just use a normal path name.
open the path using either Shell,
or the OpenNativeApp code I've posted here many times.