Change to:
if object exist(6)
if object collision(2,6) > 0 then delete object 6
endif
Your biggest problem was the odd '=' sign you had in collision expression.
Also, do not test for collision between two objects if one of the objects may not exist. Unfortunately DBPro tests both sides of AND condition even of first condition is false, otherwise you could have just said:
if object exist(6) and object collision(2,6) > 0 then delete object 6
Also make sure bullet moves in steps less than size of tank otherwise it will pass right through it without coliding!
If your mansion house needs haunting, just call Rentaghost!