Code:
Between IIf(Month(Date())<=7,DateSerial(Year(Date())-4,5,1),DateSerial(Year(Date())-3,5,1)) And IIf(Month(Date())<=7,DateSerial(Year(Date()),Month(Date()),0),DateSerial(Year(Date()),Month(Date()),0))
Code:
Between IIf(Month(Date())<=7,DateSerial(Year(Date()),6,30),DateSerial(Year(Date())+1,6,30)) And IIf(Month(Date())<=7,DateSerial(Year(Date())+3,6,30),DateSerial(Year(Date())+4,6,30))
Code:
SELECT [02_Collegiate_Details].MemberType, [02_Collegiate_Details].Season, IIf(Sum(IIf((DatePart("m",[PaymentDate])>=5 Or DatePart("m",[PaymentDate])<=7) And DatePart("m",[paymentdate])<=7,1,0))=0,Null,Sum(IIf(DatePart("m",[PaymentDate])>=5 And DatePart("m",[PaymentDate])<=7,1,0))) AS Jul, Sum(IIf(DatePart("m",[paymentdate])=8 And DatePart("m",[paymentdate])=8,1,0)) AS Aug, Sum(IIf(DatePart("m",[paymentdate])=9 And DatePart("m",[paymentdate])=9,1,0)) AS Sep, Sum(IIf(DatePart("m",[paymentdate])=10 And DatePart("m",[paymentdate])=10,1,0)) AS Oct, Sum(IIf(DatePart("m",[paymentdate])=11 And DatePart("m",[paymentdate])=11,1,0)) AS Nov, Sum(IIf(DatePart("m",[paymentdate])=12 And DatePart("m",[paymentdate])=12,1,0)) AS [Dec], Sum(IIf(DatePart("m",[paymentdate])=1 And DatePart("m",[paymentdate])=1,1,0)) AS Jan, Sum(IIf(DatePart("m",[paymentdate])=2 And DatePart("m",[paymentdate])=2,1,0)) AS Feb, Sum(IIf(DatePart("m",[paymentdate])=3 And DatePart("m",[paymentdate])=3,1,0)) AS Mar, Sum(IIf(DatePart("m",[paymentdate])=4 And DatePart("m",[paymentdate])=4,1,0)) AS Apr, IIf(Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or DatePart("m",[PaymentDate])<=5,1,0))=0,Null,Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or DatePart("m",[PaymentDate])<=5,1,0))) AS May, IIf(Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or DatePart("m",[PaymentDate])<=6,1,0))=0,Null,Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or DatePart("m",[PaymentDate])<=6,1,0))) AS Jun
FROM 02_Collegiate_Details
GROUP BY [02_Collegiate_Details].MemberType, [02_Collegiate_Details].Season;