Ok, I'll try to explain what needs to happen as best as I can, so please bear with me
There are Competitors that compete in Competitions
Trying to get a report / View that'll display the following information.
From all the competition registrations which competitors is it their first time competing in the current season.
So there's a table that stores competition registrations, a table of the competitors, etc ...
My thought process so far:
- Create a View and do a GroupBy then do a count on competitorID = 1 for all the competition registrations. Which should give me ALL competitors that's competed only once. It be back in 2000 or last year or this year, etc ...
- then another View on the Competition Registration for the current season competitions by Competitor.
- Link these two views on CompetitorID to get the list of 1st time competitors.
I don't think this thought is correct? I only got 3 records when there should be few - several hundred records.
Any ideas on how to get the result of 1st time competitors in the current season?