concatenate string and variable

[sthorne1271]

I am trying to use an INSERT command to add a row to an Access table. What I want is a string inserted that will contain a variable value in the middle.

INSERT INTO tbl_my_table (LOG_MSG, MSG_ID) VALUES ('error in step $msg_value$ occurred',$msg_id$)

The query runs fine, but it does not pick up the value of the variable $msg_value$. I tried different ways of concatenating values, but no luck.

thanks
Steve

[forumsupport]

Hello,

Please try this,

. Create a user variable say $ErrMsg$.
. Using String Manipulation command assign 'error in step $msg_value$ occurred' to $ErrMsg$.
.Use $ErrMsg$ in Insert command like this,

INSERT INTO tbl_my_table (LOG_MSG, MSG_ID) VALUES ($ErrMsg$,$msg_id$)

Hope this helps.