The OP stated early on his failure was related to a VOR approach. Later in the thread the responses relate to a RNAV procedures. It is never clear what type pf approach the OP was having an issue with. Understand that newer aircraft with FMS, the non GPS approaches (VOR, NDB, LOC) are overlay type, prone to a misunderstanding related to loading and executing/managing the FMC. If the OP has issues with understanding the correct way to execute any approach using a FMS, then by all means get those issues resolved before even attempting another training session, let alone a repeat check ride. I think the issue is more likely one of self confidence, ie; checkride itis. Its easy from the sidelines when (we) are not taking the ride, but you need to get out of your head and prepare enough that you have as much confidence in your self as you can. As others have alluded, this is not a career ender, nor a job killer, but you do need to do what it takes to regain your confidence. Good luck.