I want to make a report from a query. The query has a date column with dates throughout the year.
My end result is I want three grouping of the report 1 Group for the current Day. The second group for the current week and the third group for the current year.
Can I do these groupings from the report or the query? Do I need to write seperate queries for each grouing and then join them in one big group?