Query:count event per day and per machine

[mfaqueiroz]

Hello,
I have one table with the machine status associated with a date and an Machine, as the follow picture:




I want to do a access query that counts the number of alarms per day and per machine, do you have ideia the more efficient way to do that?
Thank you for your precious help,

 

[pbaldy]

Have you played with a totals query, grouping by machine and date (using DateValue() to isolate the date portion)?

 

[mfaqueiroz]

thanks pbaldy! little tip but was all i needed

 

[pbaldy]

Happy to help!