Sheryl,
Please include the previous reply in your reply so we know what you are referencing. Looking at your reply by itself is confusing for some of us older/mature members ;-)
Change your query to the following and your crosstab will work:
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,
IIf(Classification_Referral_Source IN ("Board-FUDT","Board-Eligibility"), "Combined Name", Classification_Referral_Source) as ClassRefSource
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#));
BTW: Nice weather we are having in MN!
Duane Hookom MVP (Eden Prairie)
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 30 Jul 2014 09:32:39 -0700
Subject: RE: [MS_AccessPros] Re: Question RE my FY query
Ok, so I got that part to work, but now when I run the query, it is asking for parameter values instead of providing data. Am I missing something?
Please include the previous reply in your reply so we know what you are referencing. Looking at your reply by itself is confusing for some of us older/mature members ;-)
Change your query to the following and your crosstab will work:
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,
IIf(Classification_Referral_Source IN ("Board-FUDT","Board-Eligibility"), "Combined Name", Classification_Referral_Source) as ClassRefSource
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#));
BTW: Nice weather we are having in MN!
Duane Hookom MVP (Eden Prairie)
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 30 Jul 2014 09:32:39 -0700
Subject: RE: [MS_AccessPros] Re: Question RE my FY query
Ok, so I got that part to work, but now when I run the query, it is asking for parameter values instead of providing data. Am I missing something?
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar