Lost!

As a general rule I'm lost in so many more ways then one. But today in particular I'm lost in dealing with the Access database I maintain at work. You see I've been trying to fix all these forms and such to match the new years of the budget were trying to do, which is all pretty droll, and I thought I had it all down. But there is one particular section which I didn't fix or change and now it doesn't work. At first I assumed the reports associated with that particular form were broken and needed to be updated, but I learned that the reports are now fixed.

What I didn't know was that the root of the problem was really the searh function in that form. The search function is allowing the reports to correctly populate some data, but not others. For example, the search will work for "4A1M" which is one of our line items, but not for "4A6M"...I can't imagine what possible trick there is that one character difference is causing problems. So the search function is kindof working, but I'm not sure what the problem is.

The reason I'm lost is that I thought I had the solution to the problem locked down, and now realized that not only did I not, but that I didn't even know the problem to begin with. And now that I've found the problem I have to go back and find what's causing it, so really I'm not only back to step one, I'm back to step zero, and my shoes have caught on fire. It's like if you were trying to bake a cake, and you thought you knew what was preventing your cake from working, but now you figured out that the ingrediants were wrong and you don't have the ones you need. Not only do you not have the correct ingrediants but you can't buy them and you have to start growing the grain to make the flour and you have no idea how to farm. That's where I'm at right now, looking up books on what kind of chickens I need on my farm.