You can not have a text message in a number field.
Post the SQL of what you tried and what is datatype of the fields.

"Bob Waggoner" wrote:

I append the record of one table to another table and I want to add the same
text to one of the appended fields. "This comes from ConcernID #" and then
have the number inserted.

I can insert the number, I just haven't been able to get the text message to
go with it.

In the append to, I have written &"This comes from ConcernID #" & Comment
(Comment is the field I'm sending the concern id to).

I've tried to put it in the field name - that doesn't work.

I have access 2003.

Thanks for your help.