Can you combine two statements in one query

[DougP]

I need to delete all records each time prior to running the insert query.

Delete From TempProjectsNotLoggedOut    INSERT INTO TempProjectsNotLoggedOut ( [Project Number], ...

Can this be done in one query?
It gives error

DougP, MCP, A+

 

[Golom]

Some DBMS systems permit constructs like

Delete From tbl[red]; [/red]INSERT INTO ...

Unfortunately, Access isn't one of them. You will need to use two statement and run them in sequence or write a stored procedure to do the delete followed by the insert.

 

[PHV]

Can this be done in one query
No, access doesn't admit multiple QL instructions.
You may consider a make table query:
SELECT ... INTO TempProjectsNotLoggedOut
FROM ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DougP]

Ok thanks

DougP, MCP, A+