Is there a way to create a query over the original. For example
This errors saying that the object already exists. I just want to overwrite the original query with the new data I recieve daily. So do i need to delete the actual query with the code below before I run the createquery or is there another method?Code:Set qryDef = CurrentDb().CreateQueryDef(myCriteria,sqlFinal)
Code:DoCmd.DeleteObject myCritiera