Comma problem in SQL

[irade92]

HI
How to solve this comma problem?
DoCmd.RunSQL "INSERT INTO tblMAK_FAKTURI (NUMBER, DATE_DOK) SELECT ('" & mNUMBER & "'" & ", " & "'" & mDATE_DOK & "'" & ")"

all values are strings
I got this message Syntax error (comma)
Thanks

 

[pbaldy]

Try without the parentheses in the SELECT clause. If the second field is date/time, the delimiter should be #. This can help:

http://www.baldyweb.com/ImmediateWindow.htm

 

[RuralGuy]

You should google the "insert into" syntax and see what you find.

 

[irade92]

Try without the parentheses in the SELECT clause. If the second field is date/time, the delimiter should be #. This can help:

http://www.baldyweb.com/ImmediateWindow.htm

Great!!! Thank you pbaldy..it works without parentheses....

 

[pbaldy]

Happy to help!