Calculating Multi Value field

[Youngfighter]

Hi All, Please have a look on the attached sample database.

How can I get the query to work in order to count specific values per day.

Thanks in advance for your time.List.accdb

[orange]

I'm suggesting you
a)drop the use of multivalued fields
b)work through this tutorial to get an appreciation of database and table design and related concepts
c) look at this link regarding reserved words in Access
d) review your need for attachment field
e)research sql for count and group by examples (start here)

Good luck