I have created a frmTimesheet form where auditors will enter their hours for audits that they've worked on. I know how to build a very basic, no-frills database, and what I'm trying to accomplish here is a bit beyond my true technical expertise.
At this point, the auditor can select his/her name on the primary Form which will filter any/all audits that they have charged time to (subForm). The subForm details the audits, dates, and hours per audit.
Problem: Some audits have the same date, but different hours associated. Example:
Auditor: Jane Smith Activity Date Hours
Admin 10/6/07 5
Acctg 10/6/07 3
Training 10/25/07 8
Is there a way on a Form to group like dates and have the hours associated with the like dates to sum, so that one can be assured that they have entered at least 8 hours on a given day?
Thank you
4 1637
Are you going to be examining your data on a table or will you eventually create a report?
If you create a report you can insert a count function to total the number of hours worked for a given date. Actually you can do this on the table too.
Let me know if this is something you're interested in.
Are you going to be examining your data on a table or will you eventually create a report?
If you create a report you can insert a count function to total the number of hours worked for a given date. Actually you can do this on the table too.
Let me know if this is something you're interested in.
Beacon-
Of course, I want to make sure that the underlying Table is accurately capturing all data, however, I would be examining the information in a report that I would create.
I am interesting in learning more as to how to do this.
Sounds like I would be unable to do this in a form...???
When you create your report, create a footer section for the hours worked and type in the following expression into a text box:
This will work for you if you setup your report to be grouped by individual and then by date. I said count in the last reply, but I realized that you were actually wanting a total.
You can do the same thing on a form using a text box.
Hope this helps...
When you create your report, create a footer section for the hours worked and type in the following expression into a text box:
This will work for you if you setup your report to be grouped by individual and then by date. I said count in the last reply, but I realized that you were actually wanting a total.
You can do the same thing on a form using a text box.
Hope this helps...
Awesome, mission accomplished. Thank you much:)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: thefirstwml |
last post by:
I am using Visual Studio.NET 2002 Professional and am attempting to
create a report on Crystal Reports for .NET.
I know that Crystal Reports can group on anything, and when I add
multiple
groups, the groups are childs of the first group.
i.e.
Group 1
Group 2
|
by: Frank |
last post by:
For my website i would like to display the age of my son in years,
months, days and hours.
For now i manage to get a result for totals. Like the total number of
days.
This is the beginning:
starttime = Date.parse("Aug 10,2003, 07:07")
sdt = new Date(starttime)
|
by: Mojca |
last post by:
What is formula that get days between two dates?
Npr: 11.03.1998 – 1.7.2005
Thank you, Mojca
|
by: Dennis D. |
last post by:
Hello:
Been working on this way too long.
DateDiff returns a Long. : Totally counter-intuitive.
Subtracting: 0400 - 0345 returns -15 : Wrong, should be +15?
Subtracting 02:00 - 00:15 with an interval of minutes returns 105 which is 2
hours minus 15 minutes, not the expected 01:45 or at least 45
Simply, there are two textboxes. Both receive a time (as a string of course)
in hours and minutes as 00:00
|
by: Carl |
last post by:
Hi,
I have a query that produces an output similar to the sample shown
below. These records are based on certain criteria and a date range
selected from a form. I need to create some kind of calcualtion or
record manipulation to do the following:
I need to subtract dates from one another, for example for ID 1 I want
to find the difference between 24-Jun-04 and 25-Jan-06 for the 2
applications for Person1.
| |
by: dath |
last post by:
Hi,
Not really a programmer here, but have been forced into the role. I was asked to develop a basic time sheet for employees to enter time. I developed the Table without a problem. I then developed a query to limit the records displayed based upon an employee last name and a month. Once again no problem. I then stareted developing the form based on the query. The form has a subform using data sheet display. Form prompts user for...
|
by: Remington |
last post by:
I am using windows 2000pro with access 2000.
I am trying to make a database for our HR department, that would allow our HR Director to type in an employee's ID number into a form and then select the dates the employee took off from work.
(I have the calander add-in 8.0 setup to easily select the dates already) There are two Date Fields, "Leave Date", and "Return Date" where the calander selections are stored. They are in the 12/25/2006...
|
by: richbneal |
last post by:
I really like the site so far and this is my first post. I have looked through some of the archives with no luck. I have also read the posting guidelines and will do my best to be clear and accurate with my problem. I am working with Access 2k / Win 2k. I have some experience and must have this figured out before Aug1.
What i am tasked with is to modify an existing process that calculates the hours and minutes worked, which is entered on a...
|
by: sqlbraindead |
last post by:
The problem is if I want to group my database on the time basis, how can reconcile the grouping of two different criteria structure?
This is an example.
Two table I want to use these to get a table with each staff and calculate their total working hours.
Master Table (2 Columns)
StaffID Grade
1 A
2 A
3 B
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |