Wow, I have been to the edge and back, my friends. This hefty ordeal will be one that they will speak of around the campfires and dinner tables for centuries to come. I will refrain from spending an fortune of precious moments on this post, expecially considering the fact that I am supposed to be working happily away right now, but rather am recording my happenings for all to see with a link to the gigantic network known as the worldwide web.
For some time now, perhaps in the range of one-two weeks, I have been in a vicious struggle with a project assigned to me. The environment of the wrestling is Microsoft Access, of the 2002 A.D. variety. Whislt in the process of attempting to produce a "whiz-bang report," my peace was sundered by the project, which demanded that I retrieve the data of an far-off land, known by some to be tblSetbackbyZone, but hereafter to be remembered as RetroFever Jane, that is, The Totally, Completely, and in All Other Ways Conquered.
I was utterly shocked by this mandate from the high and most mighty of all things pertaining to workternship, Project. I asked if he was certain in mind concerning the matter, and he rebuked me, saying, "Yes."
What could a soul do? Never had the Project been so forceful in manner as to coerce me to a far-away realm and bring back more complex data than the typical mind of a Rhinoceros Beetle can comprehend! I gazed out into the horizon with a solemn expression on my foot and picked up all the expressions of which I could think, for I would necessitate them soon in my journeys.
I thus set out, dissolving my path before me until I finally, after much tribulation from the cat5 road and its perils, arrived at the borders of tblSetbackbyZone. There were data surrounding me of all colours, shapes, and sizes. To describe them more fully, they were like marbles scattered across the expanses of space, with little fuzzies coming out like hair. But I was not distracted: I was strictly there on business. I opened my backpack in an attempt to let out my expressions of power, but they hearkened not to the freedom calling them through the open air and remained motionless, lifeless.
Oh the sorrow that tormented me then! Surely all was lost! I wandered about the strange land for many minutes, and the minutes themselves are many hours and seconds, until I looked at my watch of timeliness, and found a sticky little query clinging thereon. I seized upon the query and tossed it into the air, where it, without hesitating, gathered up some of the data which I so direly was in want.
He brought the data to me, and I rejoiced exceedingly. But my pleasure was short-lived, for when I indeed tried to use the query once more to bring in the additional data I needed, he only wandered around without success, apparently seeking the data he had already found. Again I was dashed against the rocks and left to wither in the elements' exposure and time...
But that's not the end.
No, as you will see. Now even though I searched about and verily found queries that could collect all the data I needed for the Project and more, I could only hold one query at a time. Thus my frustration was great, and there were times that I lost hope...
But that's obviously not the end either.
How bright was the afternoon when I discovered what it was I pursued for so long, the solution to all my problems and woes! I found that if I juggled the queries as I walked, they could retain the data from escaping and I would only have to juggle them in order to only have one at a time. Joy encompassed my being, and I was filled with wondrous power. That ethernet link home was a breeze and I strode with a bright countenance and much confidence in my mind.
I presented the data to Project, and he accepted it sternly. I glared at him, and he glared at me. Then we searched frantically through the newspaper clippings to find a coupon to order some pizza, but it was all to no avail. So we continued to battle.
And though I fight him still, the day is in sight where I shall subject him to my will and emerge victorious.
---
IOW, I found out how to use multiple queries in a report to get desired data. Big deal. Microsoft Access is cooler than I previously thought.