Social Events Report

[SunTop]

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 ?

[ssanfu]

I had to create my own tables using the few records you posted, so I'm not sure what will happen with the full data set.
I created 3 queries: qryWeek, qryMonth and qyrYear. Then I created a Totals query to count the record from the 3 queries.

The date should default to 2/16/2016....open the report.

[ranman256]

7 is not the current year. It would be Year(eventDate)

[AccessPower]

I had to create my own tables using the few records you posted, so I'm not sure what will happen with the full data set.
I created 3 queries: qryWeek, qryMonth and qyrYear. Then I created a Totals query to count the record from the 3 queries.

The date should default to 2/16/2016....open the report.

Props. this looks really good.

[SunTop]

I had to create my own tables using the few records you posted, so I'm not sure what will happen with the full data set.
I created 3 queries: qryWeek, qryMonth and qyrYear. Then I created a Totals query to count the record from the 3 queries.

The date should default to 2/16/2016....open the report.

You have created two tables, five queries, one form, and one report to help me ...
that is above and beyond Sir .. you really have walked the extra mile in this thread .. and your solution worked perfectly ...
Thanks !!!!

[ssanfu]

It was easier to create the db than it to write a book trying to describe how to create the queries & report.

Glad it worked for you.....