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

Rabu, 30 Juli 2014

[MS_AccessPros] Re: Question RE my FY query

Open your query in design view. Put this in a field below:

myTotal: Board-FUDT + Board-Eligibility

It's as simple as that. You can change myTotal to whatever you want to call this new field.

By the way, I didn't know we could paste images into posts. That must be something new.

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 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#));