Querying an Access 2013 Multivalue field to obtain totals of each value in a date range

[usaemtp]

I have searched for the answer to this question on the internet and have not found one that fits exactly what I am trying to do so I do not know if it is even possible. But I have a table that tracks incidents for work with a multi-value field called "Event Type." I want a query to pull data for the previous 12 months and to total each value selected from the multi-value field. I have created a query and pulled the "Date" field and the "Event Type" field to the query column window. I have the criteria that will select the previous 12 months from the Date column so that the query will use only that data. But I do not know what criteria to enter in order to total each event type selected in the "Event Type" field so that I can have a count of the 9 different event types that occurred over the past 12 months. Does anyone have any suggestions on how I can accomplish this? I would appreciate any help you can provide.


Brian

[June7]

Need to do an aggregate (GROUP BY) Totals query or build a report that uses Sorting & Grouping features with aggregate calcs in group and report footer sections.

Do you need the data summarized by event type and month? Use an expression to create a field that extracts the year and month from the date value. Use that calculated field for grouping criteria.

I NEVER use multi-value field.

[CJ_London]

you need to put the eventtype.value into the query, not the eventtype

[June7]

Review https://support.office.com/en-us/art...3-B6624E1E323A

One expression to extract year and date: Format([date field], "yyyymm")