472,358 Members | 1,977 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,358 software developers and data experts.

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 1142

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

Similar topics

4
by: Joe User | last post by:
How would you count the number of columns with a value not equal to 0 for each row in a table? Thanks! Joe
1
by: Son KwonNam | last post by:
When I try <xsl:value-of select="count('/GROUPS/GROUP')"/> on JSTL <x:transform> tag, I got the following error message. org.apache.jasper.JasperException: Can not convert #STRING to a NodeList!...
10
by: ChrisD | last post by:
I'm trying extract a count of consecutive numbers, or "unbroken" years in this case, at any particular given time. For example (simplified): CREATE TABLE #Customers ( CustNo INT, YearNo...
8
by: Tom | last post by:
Please help. I need a quick little scrpit to place on a web page that will count how many days have passed since January 1, 1970. I have ZERO experience writing ANY scripts. Anyone have any...
4
by: princeofcode | last post by:
Hey all, The following function counts for number of characters in a text area and displays error msg when it exceeds a maximum limit I would like to optimize this function so that its highly...
2
by: arrietal | last post by:
I have been trying to find a code that will help me display at the bottom of the report the number of records that where retrived for the report.
2
by: thsoundman | last post by:
Currently I am creating a Access Program that will search a list of records and then display the results of the search at the bottom of the screen in a sub form. What I want to be able to do is...
1
tuxalot
by: tuxalot | last post by:
I've copied the option group from my form, and pasted it into the report which seems to work fine. Now, I wish to total the option items in the report. So I have a query that grabs records within a...
8
by: TasmanianDevil | last post by:
Can anyone help me with a Formula in VB/excel to COUNT how many numbers are consecutive within a Row that spans 20 Columns? Example: 65 67 68 69 75 79 80 84 85 90 78 73 61 93 92 91 95 6 33 99 ...
11
wordbrew
by: wordbrew | last post by:
Hello all, I’m beginning to get a pretty good foundation in VBA, but I can’t wrap my head around this problem, even after trolling around the net searching through other posts that seemed remotely...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
1
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
0
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.