I created a query which is working wonderfully to execute data based on fy numbers, except that the FY that shows is 1 year off. All of the data that should be coming out for FY 08 is showing up in the row for FY 07. Can somebody take a look and tell me what the problem might be?
Our FY year runs from 7/01/07-06/30/08 etc.
SELECT sj_qry_first_referral_by_fy.Classification_Referral_Source, sj_qry_first_referral_by_fy.Board, sj_qry_first_referral_by_fy.Date_of_Referral, Month([Date_of_Referral]) AS CalendarMonth, Year([Date_of_Referral]) AS CalendarYear, IIf([CalendarMonth]<7,[CalendarYear]-1,[CalendarYear]) AS FY, sj_qry_first_referral_by_fy.CaseID
FROM sj_qry_first_referral_by_fy;
TIA
sheryl
__._,_.___
Posted by: Sheryl.Jones@state.mn.us
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar