Try this --
INSERT INTO 852Complaints ( MgmtRevID, [Customer Code], [Customer Name],
Complaint, [Date of Complaint], Comments, PSID, hyperlink2 )
SELECT [852ConcernTable].MgmtRevID, [852ConcernTable].[Customer Code],
[852ConcernTable].[Customer Name], [852ConcernTable].Complaint,
[852ConcernTable].[Date of Complaint], "This comes from ConcernID #"
&[852ConcernTable].ConcernID, [852ConcernTable].PSID,
[852ConcernTable].CustDocuments
FROM 852ConcernTable
WHERE
((([852ConcernTable].ConcernID)=[forms]![852Complaintsform][852ConcernFORM]![ConcernID]));


"Bob Waggoner" wrote:

I'm trying to send a number field to a memo field with the added text "This
is the concernID". Here's the SQL (without the text).