September 26, 2015 at 5:05 pm
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.
September 26, 2015 at 5:22 pm
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 those with multiple entries in different years do not show, so just the 1st Timers are resulting.
September 29, 2015 at 6:45 pm
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, has only registered once, and this year.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply