This can be done using Formula Queries. Can you tell us if there could be more than one call out on a particular day? That would affect how the formula query would be written.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 05-29-2023 00:24
From: Josh Hamilton
Subject: Report consecutive dates
Might need some more information on what sort of fields you have in the callouts table and how it's used.
Do you mean that you want a report that lists where an employee has 5 separate callout records assigned to them where I am assuming there is a date field of the callout that is used to see if those 5 are consecutive?
------------------------------
Josh Hamilton
Original Message:
Sent: 05-23-2023 10:34
From: JAW WA
Subject: Report consecutive dates
I have two tables employees and callouts where employees can report multiple callouts. I need to create a report that shows callouts if they fall within 5 consecutive dates. Need help in figuring this out. Thanks !
------------------------------
JAW WA
------------------------------