I have the following queries being called. They out put to "OUT" and "IN" tables respectfully
Both of these tables are then being merged in another query called "RESULT" which outputs to table called "RESULT"
What I want is that I do not want the user to see the "IN" & "OUT" tables. I understand that I can hide them but I would rather like to delete them. Could you please help me to delete them.
Now I have done this before but the method seems too code heavy and it exits the sub so I cannot use the same code :/
On Error GoTo EH
CurrentDb.Execute "SELECT INTER.OTCOMBO, INTER.DTCOMBO, INTER.TCOMBO, INTER.SERVICE, INTER.CLASS, INTER.[MIN]*0.65 as MIN, INTER.[LTL]*0.65 as LTL, INTER.*0.65 as 500, INTER.[1M]*0.65 as 1M, INTER.[2M]*0.65 as 2M, INTER.[5M]*0.65 as 5M, INTER.[10M]*0.65 as 10M, INTER.[20M]*0.65 as 20M INTO Get65 FROM [INTER] WHERE INTER.TCOMBO=" & Chr(34) & termcombo & Chr(34) & " AND INTER.SERVICE=" & Chr(34) & [Forms]![Point2Point]![servicecombo] & Chr(34) & " ORDER BY INTER.CLASS", dbFailOnError
If Err.Number = 3265 Then Resume Next
MsgBox "error " & Err.Number & ": " & Err.Description
The above code is being used to delete a table called "Get65"