[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