Hi, I have this simple insert sql statement
I can't figure out how to insert the second field with dashes.Code:DoCmd.RunSQL "INSERT INTO tbl_Requisition_Exclusions (Item_ID, Item_ID_dashes) VALUES ('" & txtExcludeItem & "', '" & txtExcludeItem & "')"
The value would be entered as 12345678911 in the text box and I need to save it as is in Item_ID and as 12-3456-7891-1 in the second field Item_ID_dashes.
One way is to first enter it as is then update the table but I'd rather insert it the right way of possible as it should require less computing.
Thanks.