NEVERMIND.

Think the user is incorrect or their criteria is incorrect.

checked on a person they are saying they have competed. looked at all registrations and that particular person, under that name,...

FYI - It seems the latest code with the >=GetDate() added and in the In Select or rather NOT EXIST section to <=DateFromParts(YearGetDate()),6,30) is correct.

I've checked a few records and...

I was originally thinking do a Count = 1 but don't know how to then apply only for the current season and where the In Select came from.

That produces If then result. Is there a way to apply to produce the result of 1st Timers?

Using it against sample table I have locally, I applied it as such.

SELECT...

Ed Wagner (9/26/2015)

---

If you want a tested solution, please take the time to read the article pietlinden and Jeff mentioned. There's also a link to it in my signature....

Luis,

Not sure what that's for.

The code I shared produces 6/30/2015 + SeasonEndDate with >=DateFromParts(Year(GetDate()),6,30)

I need it to produce 6/30/2016 +

but in any given year it needs to see that GetDate()...

After further testing the last shared code is only valid for the season that ended this year on 6/30/2015.

I tried changing the parameters so it will show 'current season' which...

So this worked! Or so it seems to be producing results as expected.

SELECT CompetitionName, CompetitionCategory, EventType, SkaterMbrNo, FirstName, LastName, Email, HomeClub, PartnerFName, PartnerLName,...

I got this so far

SELECT *

FROM competitions c

WHERE c.season>=DateFromParts(Year(GetDate()),6,30))

AND NOT EXISTS (

SELECT *

FROM competitions x

WHERE x.season<> DateFromParts(Year(GetDate()),6,30))

AND x.CompetitorID = c.CompetitorID

)

will be trying a modification this tomorrow with the actual fields...

Ok, example of how to do that?

I only know how to do the GroupBy then change the type on the field to Count then did Filter on that Count to...

lol!

I wouldn't have, though I don't know enough to do that anyway.

That's what I did. I created a View.

Then using the built-in parameter in Excel via MS Query for the...

Finally figured it out.

Changed from this

"INNER JOIN lookup.MemberTypes AS mt ON mt.Id = attribute.PersonMembership.MembershipTypeId AND mt.MemberGroup = 'Regular Member' " & _

"LEFT OUTER JOIN entity.Organization AS org ON org.Id =...

Lowell (8/26/2015)

---

just a guess, but cound the query might be truncating at exactly 2000 characters? it looks pretty darn close, maybe there's an odbc limitation somewhere?

can you switch to calling...

I also copied the SQL that works in SSMS and used in the Properties Definition for the Connection and split it in the Excel Module:

Sub Button1_Click()

Dim StartingBatchDate As String, EndingBatchDate...

Tried variations of the 'pm' and attribute.PersonMembership and still failing.

NOTE: When the 'pm' at the end of Split3 is removed, the error is on JOIN. All else the error is...