I’m having a database problem at work that I don’t know enough to fix. If any “Alas” readers who know database stuff can glance at this and tell me if they see what my problem is — my problem involving the database, that is, I may have many non-database-related issues that there’s no need to bring up at this moment — I’d appreciate it.<\/p>\n
Heck — I’ll do a cartoon of any celebrity or any “Hereville” character of your choice to anyone who fixes the problem!<\/p>\n
<\/p>\n
So at my workplace, a nonprofit historic site<\/a>, we use Microsoft Access to keep track of donations and addresses.<\/p>\n Today, we want to output a list of everyone who hasn’t given us money since August 1 2007. To do this, we use a query that looks like this (for posting on “Alas,” I’ve replaced ( with { and ) with }, because posting double-parenthesis in “Alas” leads to difficulties. But in the real thing I’m using parenthesis):<\/p>\n SELECT Members.Zip, Members.[First name], Members.[Last name], Members.[Address 1], Members.[Address 2], Members.City, Members.State I have no idea how to use this stuff, but this is a query that I’ve used many times in the past, and all I have to do is change the date and it works. Until today.<\/p>\n Today, for some reason, it won’t work for dates before 01\/14\/08. If I input 01\/14\/08, it appears to correctly output a list of every member who hasn’t donated money since the 14th {which is to say, pretty much all of them}. But any date earlier than that — such as 01\/13\/08 or the date I want to use, 08\/01\/07 — and it outputs a blank list, indicating that absolutely all of our members have given money since that date. {We’d be happy if that were so, but alas, it’s not so.}<\/p>\n Oddly enough, another query I use — this time to tell me everyone who HAS given us money since August 1 2007, plus the retirement homes on our mailing list — seems to be working perfectly. Here’s what that one looks like:<\/p>\n \nSELECT Members.Zip, Members.[First name], Members.[Last name], Members.[Address 1], Members.[Address 2], Members.City, Members.State To qualify as having “solved” my problem, you have to explain it to me in terms so clear that I’m capable of getting it working. :-}<\/p>\n","protected":false},"excerpt":{"rendered":" I’m having a database problem at work that I don’t know enough to fix. If any “Alas” readers who know database stuff can glance at this and tell me if they see what my problem is — my problem involving … Continue reading
\nFROM Members
\nWHERE {{{Members.Zip}>”0″} AND {{Members.MemberID} Not In {SELECT Gifts.MemberID FROM Gifts GROUP BY Gifts.MemberID HAVING MAX{Gifts.Date} >= #01\/14\/08# }} AND {{Members.Deceased}<>Yes} AND {{Members.[No Mail]}<>Yes} AND {{Members.Retirement}<>Yes} AND {{Members.[No Begging]}<>Yes}}
\nORDER BY Members.Zip, Members.[Last name];\n<\/p><\/blockquote>\n
\nFROM Members
\nWHERE {{{Members.Zip}>”0″} AND {{Members.MemberID} In {SELECT Gifts.MemberID FROM Gifts GROUP BY Gifts.MemberID HAVING MAX{Gifts.Date} >= #08\/01\/07# }} AND {{Members.Deceased}<>Yes} AND {{Members.[No Mail]}<>Yes}} OR {{{Members.Retirement}=Yes}}
\nORDER BY Members.Zip, Members.[Last name];<\/p><\/blockquote>\n