Here is my query to get a list of all groups for all months. I have also attached the output in a file. As you can see from the data results, the Month column presents a challenge. I would like to find all records between the months of December to February. How could I do so in SQL? I imagine that I will have to convert the Month column to a date type somehow.
select P.Agency, M.Month, F.Description,F.GrossAmount,F.NetAmount,F.InKindAmount from tblOrgProfile P Join tblorgMonthlyReport M on M.AgencyID = P.AgencyIDJoin tblOrgMonthlyFunds F on F.MonthlyID = M.MonthlyIDWhere Agency <> 'Administrator'order by Agency