I hope everyone's' summer is going well.
I have been "learning" Access slowly, but love the things I am learning. I need a little help though. Our fiscal year goes from 7/1/07-6/30/08 etc. when I run the query, it gives me all of the correct data, but it lists all of the information under the wrong fiscal year (puts the FY10 data under FY09 heading, FY09 data under FY08 heading etc).
Can anyone tell me what I might be doing wrong?
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;
Thanks.
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