Confused & Frustrated

For as long as I can remember I've wanted to be a nurse. I started going to school to pursue a degree in Nursing. After completing all of the pre-requisetes for the Nursing program, I was placed on the waiting list which is as far as I got. I got bumped from the list not once, not twice, but three times because there were people waiting longer than me or that had better GPA's than me. Now I was an A/B student so my grades weren't bad. Each time I got bumped I had to take filler classes so that my student loans wouldn't go into repayment, by the third time I had run out of classes that related to my field of study or that interested me. I made the decision to drop out of the program because at the rate things were going I'd be 40 before I graduated with an RN degree. I've thought a lot about what I wanted to do instead and finally decided to go into criminal forensics. Now I'm struggling with the fear of not being able to find a job once I graduate. I live in Iowa and I just don't see a future in it around here and at the moment I can't even consider relocating. So, now I'm back to square one and don't know what to do with myself. I'm scared of going to school and being stuck doing something I hate and I'm scared of picking a field that will get me nowhere because of the lack of jobs. It's so stinkin' frustrating I want to scream. I want to set a good example for my kids and graduate from college and I want to make my mom proud because I would be the first to graduate college in my family. The career counselors at the college are essentially worthless and couldn't help me and actually made me more confused and frustrated than before I talked to them. I'm a science minded person so I know I want to do something in that category but I just don't know what. If anyone has any suggestions I would LOVE to hear them!