I have a table contains the attendance records of all customers, I want to count the no. of times a Customer_ID attended the class (Date) within each Anniversary Period (based on the Join_In_Date), and return the value to another report like below format, is there any way I can do so? Thanks a lot!

Customer ID            Range                                                               Count

================================================================

8888                        Year 1- 16 Nov-2015 - 15 Nov 2016                      2

8888                        Year 2- 16 Nov 2016 - 15 Nov 2017                      3

8888                        Year 2- 16 Nov 2017 - 15 Nov 2018                      4

8383                        Year 1 -13 Sep 2016 - 12 Sep 2017                      3

8383                        Year 1 -13 Sep 2017 - 12 Sep 2018                      1