Hello everyone
I have a table that records social events that happens during the year, for example:
EventID EventType EventDate 1 Bingo Game 2/15/16 2 Poker Game 2/20/16 3 Barbecue 3/5/16 4 Barbecue 5/11/16 5 Poker Game 7/20/16
I need to create a report from this table that counts and summarizes the events that happened each current week, current month and current year, for example:
EventType CurrentWeek CurrentMonth CurrentYear Bingo Game 1 3 7 Barbecue 2 8 15 Poker Game 1 3 6
I have created a query and then used the Totals column count function on the EventID column and EventDate column and Grouped By EventType column. Next I put a filter in the criteria of the EventDate column to get the current week, but then I have realized that I only can put one filter at a time in the EventDate column, so how will I get the Current month and Current Year columns in my report ?