Recent content by helpangel

BRILLIANT! THANK YOU SO VERY MUCH for the SOLUTION! Thank you also for your patience with me. I have a lot to learn still

Ok, I did not know that. Thank you! I just tested with the +6 and +7 and it still results to the same totals as the Dec. totals?? IIF3 Total 954 889 941 1055 With: Total: IIf(Month(Date())<7,IIf(Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or...

Ah, yes, sorry, your post #33 has been marked with Thanks :) Not sure though, we are getting the same results from what I've been getting thus far.

Sorry that I am lost ... I get the correct numbers from the Dec through Apr columns using the formula and by change it from -5 to -6 ToDate: IIf(Month(Date())<7,IIf(Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or...

?? It's doing the same thing, it's showing the same totals as Dec prior to Dec? This is where I am stuck. It reconciles from Dec on but prior to Dec they do not. It just repeats the totals from the Dec column for Nov, Oct, etc ... ToDate...

Solo712, :( If there's another and better way, I'm open to it since I am stuck with what I have. I just don't get how it works for several of the months but doesn't work for the other months?

I'm further now then before but stuck in verifying past Dec. Any idea? IIf(Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or DatePart("m",[PaymentDate])<=Month(Date())-6,1,0))=0,Null,Sum(IIf(DatePart("m",[PaymentDate])>=5 And 7 Or DatePart("m",[PaymentDate])<=Month(Date())-6,1,0))) If I do -7...

? Both queries are grouped by Season though? The report will always look at 4 seasons with 4 years of membership payments since these Collegiate memberships are for 4 season (4 years). From current season year + 4 2015-2018 this year 2016-2019 next year and so on

Since I need it to match the query ByFiscalYear, then ... Can I change this formula to get it to match? If so what's the correct formula to achieve this? ToDate: IIf(Sum(IIf(DatePart("m",[paymentdate])>=5 And 7 And...

Humh, ok. How do I get them to match for each month? I was thinking that as long as I have exclude current month except when it's May or Jun it would match. The Mar and Apr columns do match but NOT Feb. When I do <>Month(Date())-3 or 5 or 6 I get: which is also incorrect. Season...

Sorry, let's just go with verifying your formula for other months. Have you downloaded the database? I attached it making sure it has what I'm talking about so it makes sense from what I'm stating here to the actual queries and formulas in the db. For purpose of testing There is one table, as...

Lol! Sorry. Ok, so this looks like it works but, sorry, not sure how to test it? IIf(Month(Date())=5 Or Month(Date())=6,True,IIf(Month([PaymentDate])=5 Or Month([PaymentDate])=6,False,True))=TrueFull SQL TRANSFORM Count([02_Collegiate_Details].MembershipNumber) AS CountOfMembershipNumber...

plog, So with the further testing it seems it's not right :( I was testing this <>Month(Date())-2 Or 5 Or 6and it's not correct should be: Feb 935 874 921 1042 but getting 940 876 931 1047 See attached db and the queries: ByFiscalYear and Query1...

Yes, sorry, ONLY for May or Jun. Although thinking about I think it'll be fine. I was thinking that there might be current year May or Jun payments for the current seasons but I think they wouldn't show anyway. BUT in case they do they need to be excluded.

This also results in NULL where "txtDate" is Date()