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!
0 1220 Sign in to post your reply or Sign up for a free account.
Similar topics |
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
|
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!
but, if I try that on Sonic XIS XSL transform API It works fine.
What's the problem?
Java(apache JSTL) does not support XPath functions?
|
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 INT,
IsCust CHAR(1)
|
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 suggestions?
As for what is displayed on the screen, I just want it to say:
Today is: 12578 (or however many days have passed since that date.)
|
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 portable
and elegant
if anybody could do. It will be of great help. Also I would like to add
mincount
ie: a text less than mincount should raise error
----------------------
| |
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.
|
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 display the results of the subform into a report. But I cannot for the life of me figure out how to do it. Coding is not my forte so feel free to dumb it down for me. I was thinking I would need to create string and then do
str = ???
DoCmd...
|
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 given set of dates. So, the result on the report is a series of records, one line at a time, and the option group is placing option a,b,c,d,e in their respective places. So far so good. Now, I wish to sum these options individually. Count of...
|
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
The answer to the above example should be a Count of 11.
In order to illustrate what I mean to say that I require a total count of the
individual numbers that make up the consecutive. In the example above, we do the counting in this way: So,...
|
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 related. So I am hopeful that some (always) awesome and helpful Bytes brain power can be thrown my way.
If it’s even possible, I would like to be able to count the vacation dates that my employees have taken consecutively (doesn’t matter if they...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |