SELECT ID, demDate, Year(demDate) AS Yr, Format(demDate, "mmm") AS Mo, dem19 AS Data, "19" AS Cat FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), dem2040, "2040" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), dem4160, "4160" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), dem61plus, "61plus" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), demFemale, "F" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), demOther, "O" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), demMale, "M" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), demAboriginal, "A" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), demEthnic, "E" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), demNonAboriginal, "NonA" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssNonLegalAdv, "NonL" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssBirthControl, "BC" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssBusTickets, "BT" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssNonSTVCounselling, "STV" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssCrisis,"C" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssHealthInfoReferral, "H" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssIncomeTax, "I" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssMiscInfoRefer, "M" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssLGBTQ, "LGBTQ" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssDonationsClosetNumberBags, "D" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssProBono, "P" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssSupport, "S" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssNumPeopleUsingCloset, "N" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), wssClosetVolunteerHrs, "CVH" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), povFoodShelf, "FS" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), povFoodHampersDist, "FH" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), gfbGoodFoodBoxesSld, "G" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), gfbAmntFoodPurchased, "AFP" FROM Demographics
UNION SELECT ID, demDate, Year(demDate), Format(demDate, "mmm"), safApplicantsWWHA, "AW" FROM Demographics;