[belajar-access] SQL Syntax

 

Sore,

Kenapa yay Syntax SQL saya erorr terus, too view parameter expected 1

Dim SQ As String, DB As Database
Set DB = CurrentDb()
SQ = "INSERT INTO COBA2 ( NP, U120, DEPT ) SELECT NP, U120, DEPT " _
& "FROM QRY_UMURSTOK_GLB WHERE U120 > 0 And DEPT = '10'"
DB.Execute "DELETE * FROM COBA2"

MsgBox SQ
DB.Execute SQ

Sudah cek sana sini masih aja error.

Thanks

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___