Rabu, 01 Agustus 2012

[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

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

Tidak ada komentar:

Posting Komentar