How to count consecutive callout days > 1 on a report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kim Mitchell

    #1

    How to count consecutive callout days > 1 on a report

    I've been asked to create a report that shows the days a person has called out of the office. If they have called out more than 1 day in a consecutive time frame, they should be appearing on the report.

    There is a table called tblCallout which lists the associate's name, ID number, supervisor, Business Area (BA), date, timecode and hours taken.

    I created a query to list and group this information by
    BA, SUP, AssocName, hours taken and date. The query has a parameter to allow the user to select the start and end dates.
    On the report, I have it grouped by BA, SUP, Assoc Name. IN the details section it lists the name, hourstaken, time code and date.
    On the details footer I am counting the number of dates listed.

    I would like the report to only show those counts that are greater than 1.

    I can do a totals query that shows the greater than 1 but it doesn't show the details which would be the dates.

    Any ideas?

    Thanks!
Working...