frustrated and disappointed

Hello, I need some advice- I starting school in fall of 2002, didn't know what I wanted to do at first but for the past 2 years have been trying to fullfill local schools requirements to get accepted into either a ADN program or a BSN program. One school informed me that there is a "waiting list" and its about 2 1/2- 3 years long. The other school said I have a good chance getting a spot in the fall of 2007, the other school goes simply by GPA and hasn't accepted anyone under a 3.98 in 2 years, and the last school with the BSN program requires 2 chemistry classes, which puts me behind anyways. AHHHHH, what do I do? I just want to scream! However, I am currently enrolled in a CNA class in hopes it will get me some experience until I can get in a program and save some money while doing so. Just in case you all have any advice for me, the school I am currently attending is Mott Community College, the college that informed me of spots open for fall of 07 is Oakland Community College. Anyone out there have any advice, or similar experiences?