Cricket appearances query

[Hornet44]

Hi,
I have inherited an Access Database which records details of my cricket clubs matches in order to, primarily, produce batting and bowling averages.
There are three tables - Fixtures(to give date of each match), Players (just names) and Scoreboard (date of match - 11 times, names of the 11 players and batting/bowling/fielding details).


There are then three queries - Batting average, bowling average and fielding stats.
This all works fine. What I need help to produce is a query which will give number of appearances in a given season (year) since not all players will bat in every game they play. Ideally this would give me a list of all player names and a number, nothing more.
Any assistance would be much appreciated

[June7]

So Scoreboard lists player even if they did not bat? Provide sample data. If you want to provide db for analysis, follow instructions at bottom of my post.

[Hornet44]

All players listed whether they bat or not.

ScoreBoardID	FixtureTag	NameTag	Runs Scored	How Out	Fours	Sixes	Overs	Balls	Maidens	Runs Conceded	Wickets	Catches	Stumpings	Byes	Leg Byes	Wides	No Balls	Penalty Runs
2527	06/07/2019	Andy Lachal	7	Caught	4		4	24	0	19	2
2528	06/07/2019	Adam Jackson	17	Bowled	1	1		0
2529	06/07/2019	Krish Suntharalingam	1	Caught			4	24	0	16	1	1
2530	06/07/2019	Rob Smith	22	Caught	2			0
2531	06/07/2019	Himesha Rajapaksha	8	Caught	2		4	24	0	27	0
2532	06/07/2019	Andy Hayward	7	Bowled				0
2533	06/07/2019	George Silcock	27	Not Out	3	1	4	24	1	22	2
2534	06/07/2019	Marc Wilson	10	Not Out	2			0				1
2535	06/07/2019	Wayne Clements					4	24	0	21	1
2536	06/07/2019	Branwell Govier						0				1
2537	06/07/2019	Mick Asplen						0

[June7]

Try an aggregate query. Review https://www.teachucomp.com/aggregate...cess-tutorial/

Or build a report and use its Sorting & Grouping features with aggregate calcs. Report allows display of detail records as well as summary data.