Delete query

C

Chris

The following code INSERTS the results from the select query. I would like
to change the code to DELETE the results from the select Query. How would I
do this?

Dim strSQLInsert As String
strSQLInsert = "INSERT INTO tblTeamTask ( TeamObjectiveID, ObjTaskID,
TeamTask )" & _
"SELECT DISTINCTROW qryCorrectTeamObjTasks.TeamObjectivesID,
qryCorrectTeamObjTasks.ObjTaskID, qryCorrectTeamObjTasks.Task" & _
" FROM qryCorrectTeamObjTasks" & ";"

DoCmd.RunSQL strSQLInsert
 
S

Steve Schapel

Chris,

I think you mean like this...
strSQLDelete = "DELETE * FROM qryCorrectTeamObjTasks"
 
Top