adding hyperlinks to query results

[tgwarrior]

I have two fields, one with a name, one with an email
address. (Not all
recordsets include an email address for the person's name.)

Ideally, I'd like to have the query add
a "mailto:<address>" HTML tag for
every name that also has an email address. Can that be
done?

Thank you for your assistance!

michael munson
(e-mail address removed)

 

[Van T. Dinh]

Use a Calculated Field in your Query:

MTAdd: IIf(IsNull([Address]), "",
"MailTo:" & [Address])

HTH
Van T. Dinh
MVP (Access)