[MS_AccessPros] Re: Help needed with my FY query

 

Sheryl

I responded to your first post. See message #108469

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

 

---In MS_Access_Professionals@yahoogroups.com, <Sheryl.Jones@state.mn.us> wrote :

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: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Yahoo Groups

Did you Know?

Learn about attachment settings in your groups.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___