Right now i have a query on top on another query for a certan count. I’m wondering if there is a way to turn it into a single query.
the data is say 1,2,3 time day count.
For report/query I need to pull 1,2,3 into say 1-5 and add them together but I also need say 6-10 and so on.
I had set it up so that it’s all sererpated querys cause if i pull it all together it doesn’t add the times together just pulls the between count.
Hope that makes sence, I’m the worst at explaining myself lol