Multivalue field queries in MS Access 2013

By usaemtp ·
Tags: Software
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums