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) &
Donald QuigleyPosted May 21, 2020, 12:32 PM
UPDATE tblCensus4 SET tblCensus4.[Desc] = [Desc] & Chr(13) & Chr(10) & "Household Members:" & Chr(13) & Chr(10) & " " & [GivenName] & " " & [Surname] & " ";
Laxmidhar SahooPosted May 21, 2020, 6:30 AM
Rajat JaiswalPosted May 20, 2020, 5:12 AM