Append queries with added information
On Jul 7, 12:29*pm, 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.
post the SQL
It should be something along the lines of
"INSERT INTO DestinationTable(field1, field2) VALUES ('Value1', 'This
comes from ConcernID #'" & me.txtComment & " ')"
|