You have parenthesis in the SELECT clause that shouldn't be there
Code:
INSERT INTO TempComments (CustomerID, CommentUser, Comments)
SELECT (CustomerID, 'SMS', 'This is a test') '<<<--- remove parenthesis
FROM Customer WHERE CustomerID > 'ABC-123456'
Try the select query first
Code:
SELECT CustomerID, 'SMS', 'This is a test'
FROM Customer WHERE CustomerID > 'ABC-123456';
This should show what records would be selected .
Now the append query (it worked for me)
Code:
INSERT INTO TempComments (CustomerID, CommentUser, Comments)
SELECT CustomerID, 'SMS', 'This is a test'
FROM Customer WHERE CustomerID > 'ABC-123456';