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!