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:
I really just need the final results [Count of Days with Miles Over 20]. Any guidance provided would be appreciated.
:)
------------------------------
Dirk Ruana
------------------------------
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
------------------------------