469,128 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

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!
Nov 11 '10 #1
0 1060

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Joe User | last post: by
10 posts views Thread by ChrisD | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.