Adding a string variable to the end of an INSERT query

[ThisIsntMyRealName]

Hey guys, I have this query below, my goal is to simply INSERT all of the fields from one record into another table, plus add one more string field at the end of that, what is the syntax for this?

Here is my query so far:

CurrentDb.Execute "INSERT INTO [Adage_IMMP_Combined_Join＿Live＿Exceptions] (Order_ID_Adage, Order_ID_IMMP, Join_Key, POH_Adage, POH_IMMP, Item_ID_Adage, Item_ID_IMMP, WHS_Code_Adage, WHS_Code_IMMP, Qty_Adage, Qty_IMMP, Lot_Adage, Lot_IMMP, User_Adage, User_IMMP, Trans_Date_Adage, Trans_Date_IMMP, Report_Date＿Start, Report_Date_End, System_Adage, System_IMMP) " _
& "SELECT [Adage_IMMP_Join].Order_ID_Adage, [Adage_IMMP_Join].Order_ID_IMMP, [Adage_IMMP_Join].Join_Key, [Adage_IMMP_Join].POH_Adage, [Adage_IMMP_Join].POH_IMMP, [Adage_IMMP_Join].Item_ID_Adage , [Adage_IMMP_Join].Item_ID_IMMP, [Adage_IMMP_Join].WHS_Code_Adage , [Adage_IMMP_Join].WHS_Code_IMMP, [Adage_IMMP_Join].Qty_Adage, [Adage_IMMP_Join].Qty_IMMP, [Adage_IMMP_Join].Lot_Adage, [Adage_IMMP_Join].Lot_IMMP, [Adage_IMMP_Join].User_Adage, [Adage_IMMP_Join].User_IMMP, [Adage_IMMP_Join].Trans_Date_Adage, [Adage_IMMP_Join].Trans_Date_IMMP, [Adage_IMMP_Join].Report_Date_Start, [Adage_IMMP_Join].Report_Date_End, [Adage_IMMP_Join].System_Adage, [Adage_IMMP_Join].System_IMMP FROM [Adage_IMMP_Join]", dbFailOnError

 

[Norie]

'Your string here' AS NameOfField.

 

[ThisIsntMyRealName]

Would it be possible to select * from table1 and then somehow combine another string from VBA with that select statement results? No idea how to format that!

 

[Norie]

Sorry, but where does VBA come into this?

Did I miss something?

 

[ThisIsntMyRealName]

Yes thats VBA, for example, I want add a variable like

dim strErrorString as String
strErrorString = "System 1 Lot Field is blank is blank."

I have a table mentioned above to insert the information into and I want to add this as the last field called 'Exception_Reason' which sits at the very end of the new table, otherwise the two tables have the same information, get it now?

I realize I could just assign all the variables to individual strings, but I'd rather not do that!

 

[Norie]

If you mean you want to add a particular string for each record then you can't do it like this.

Is the string you want to add in another table linked to the table you are getting data from to append records?