Conditional Counting of Field Summary

Working of a Work Ticket System and need to the number of days on a ticket that miles driven over 20.  Each ticket will most likely have several mileage entries per day.

I am not sure if I can use a summary report.  But this would be the basic idea:

Labor Date	Mileage Driven
02/11/2021	30
02/12/2021	19
02/14/2021	46
02/15/2021	60
02/16/2021	15
02/17/2021	21
02/18/2021	23

 

 

[Count of Days with Miles Over 20] = 5

I really just need the final results [Count of Days with Miles Over 20].   Any guidance provided would be appreciated.

:)

------------------------------
Dirk Ruana
------------------------------