I'm not sure what exactly you are seeking.
I looked at your database. I created a query to separate the observation based on quarter.
where month1-3 Q1, 4-6
Q2, 7-9 Q3 and 10-12 Q4.
Code:
SELECT birdshome.Bird
,IIf(Month(ObservationDate) BETWEEN 10
AND 12
,"Q4"
,IIf(Month(ObservationDate) BETWEEN 7
AND 9
,"Q3"
,IIf(Month(ObservationDate) BETWEEN 4
AND 6
,"Q2"
,"Q1"))) AS Expr1
,Count(birdshome.NumberSighted) AS CountOfNumberSighted
FROM birdshome
GROUP BY birdshome.Bird
,IIf(Month(ObservationDate) BETWEEN 10
AND 12
,"Q4"
,IIf(Month(ObservationDate) BETWEEN 7
AND 9
,"Q3"
,IIf(Month(ObservationDate) BETWEEN 4
AND 6
,"Q2"
,"Q1")))
ORDER BY birdshome.Bird
,IIf(Month(ObservationDate) BETWEEN 10
AND 12
,"Q4"
,IIf(Month(ObservationDate) BETWEEN 7
AND 9
,"Q3"
,IIf(Month(ObservationDate) BETWEEN 4
AND 6
,"Q2"
,"Q1")));
Result for Bird Sightings by Quarter
(it might give you some ideas; you could use a query to get values by Month, etc.
Others more familiar with charts may have other suggestions)
Bird |
Expr1 |
CountOfNumberSighted |
American Crow |
Q1 |
18 |
American Crow |
Q2 |
12 |
American Crow |
Q3 |
6 |
American Crow |
Q4 |
22 |
American Goldfinch |
Q2 |
7 |
American Goldfinch |
Q3 |
42 |
American Robin |
Q1 |
17 |
American Robin |
Q2 |
77 |
American Robin |
Q3 |
85 |
American Robin |
Q4 |
41 |
XXX |
Q1 |
0 |
XXX |
Q4 |
0 |
Good luck with your project.