ACCESS FEED: [MS_AccessPros] Re: Question RE my FY query

Rabu, 30 Juli 2014

[MS_AccessPros] Re: Question RE my FY query

I have another question regarding another part of this report I am working on that perplexes me.

I have a Column called Classification_Referral_Source. It contains 5 types of referral sources: Self_Report, Third Party, Board Action, Board-FUDT, Board-Eligibility; the two latter ones always need to be added together for reporting purposes.

Is there a way that would either create an extra column to add all of the Board-FUDT and Board- Eligibility numbers together or that would replace those two columns with the total of the two?

This is what I am working with thus far. Thanks your your kindness. Im really new at this...

SELECT Month([Date_Closed]) AS CalendarMonth, Year([Date_Closed]) AS CalendarYear, IIf([CalendarMonth]>6,[CalendarYear]

+1,[CalendarYear]) AS FY, sj_qry_close_by_referral_by_fy.CaseID, sj_qry_close_by_referral_by_fy.Date_Closed, sj_qry_close_by_referral_by_fy.Board, sj_qry_close_by_referral_by_fy.Classification_Referral_Source

FROM sj_qry_close_by_referral_by_fy

WHERE (((sj_qry_close_by_referral_by_fy.Date_Closed) Between #7/1/2007# And #6/30/2014#));