Can anyone tell me where my syntax error is - i thought that if something is hardcoded like TR0034 it doesnt need any quotation marks?
strsql = "Insert into tblWorking ( STU_ID, STU_SURNAME, STU_COURSE_CODE, STU_STANDING )"
strsql = strsql & "Select tblIncoming.STU_ID, tblIncoming.STU_SURNAME, tblIncoming.STU_COURSE_CODE, tblIncoming.STU_STANDING"
strsql = strsql & "From [tblIncoming]"
strsql = strsql & "Where [tblIncoming].STU_COURSE_CODE = TR0034 "
db.Execute (strsql)
strsql = "Insert into tblWorking ( STU_ID, STU_SURNAME, STU_COURSE_CODE, STU_STANDING )"
strsql = strsql & "Select tblIncoming.STU_ID, tblIncoming.STU_SURNAME, tblIncoming.STU_COURSE_CODE, tblIncoming.STU_STANDING"
strsql = strsql & "From [tblIncoming]"
strsql = strsql & "Where [tblIncoming].STU_COURSE_CODE = TR0034 "
db.Execute (strsql)