It was some combination of not eating and not having the right environment that led to my brain fade, I’m convinced of it. I went and grabbed some lunch, came back to the office, popped in an appropriate Clash CD to get the mind moving, and voila! The answer hit me. I was doing two seperate queries and trying to pull those back together in one export, but what I should have been doing is one query covering both years of payments and then doing a report based on that one query, thus not eliminating all the people who only had a payment for one of the two years, which is what I had been doing by thinking of each year as a seperate query and then pulling them back together.
It seems so simple now, what was I thinking this morning? 🙂
Follow these topics: Uncategorized