KINGOFCHAOS17
Member
- Local time
- Today, 17:13
- Joined
- Mar 20, 2020
- Messages
- 31
I have a crosstab query which is currently grouping the data by year (see attached screenshot). It pulls data based on a DLookUp in another table (screen shot attached). The dates in the table will always be input as a complete 12 month range. This range can start anytime in the year and will cross calendar years. For this example how would I group the data from March 2017 to February 2018, March 2018 to February 2019, and finally March 2019 to February 2020. I need the solution to be dynamic based on the dates entered in the