Syntax/format question

Question

The text below is the "beginnings" of an UPDATE query. I'm trying to get the text in red to form a string, using the yellow items from 3 fields, to concatenate into an another field. The special characters are preventing me from formatting this statement correctly. Unfortunately, they have to be used as written to get them into a genealogy website, where they will create URL links to people pages.

 

Any guidance will be appreciated.

 

UPDATE tblCensus4 SET tblCensus4.[Desc] = [Desc] & Chr(13) & Chr(10) & "Household Members:" & Chr(13) & Chr(10) &

 

<a href="https://donquigley.net/getperson.php?personID=I[IDER]&tree=QD"> <font color="Blue"> [GivenName] & ' ' & [Surname]</font> </a>;