If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Append queries with added information
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. |
#2
|
|||
|
|||
Append queries with added information
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. |
#3
|
|||
|
|||
Append queries with added information
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). 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], [852ConcernTable].ConcernID, [852ConcernTable].PSID, [852ConcernTable].CustDocuments FROM 852ConcernTable WHERE ((([852ConcernTable].ConcernID)=[forms]![852Complaintsform]![852ConcernFORM]![ConcernID])); "KARL DEWEY" wrote: 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. |
#4
|
|||
|
|||
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 & " ')" |
#5
|
|||
|
|||
Append queries with added information
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). |
Thread Tools | |
Display Modes | |
|
|