Employee's input the shifts they want, once I have all this data I need to determine who will get what shifts depending on a reliability %, if thats the same then I look at the time stamp.
I have come to the point where I am pulling out the duplicate date's in a query.
Name Date Shift Reliability
Buck, Jack 1/2/2008 4:00 PM-12:30 AM 0.16254
smith, frank 1/2/2008 4:00 PM-12:30 AM 0
Jones, Bobby 1/3/2008 3:30 PM-12:00 AM 0.1111
Apex,Silvia 1/3/2008 3:30 PM-12:00 AM 0.5714
Now, I need to have it look at the dates that are the same and out of those,the lowest reliability should get the overtime. For example (1/2/2008, 2 entries, 0 Reliabilty should get Overtime).
Does anyone know of any function that would allow me to get this result?
Any help appreciated!!!!
1 2474
Employee's input the shifts they want, once I have all this data I need to determine who will get what shifts depending on a reliability %, if thats the same then I look at the time stamp.
I have come to the point where I am pulling out the duplicate date's in a query.
Name Date Shift Reliability
Buck, Jack 1/2/2008 4:00 PM-12:30 AM 0.16254
smith, frank 1/2/2008 4:00 PM-12:30 AM 0
Jones, Bobby 1/3/2008 3:30 PM-12:00 AM 0.1111
Apex,Silvia 1/3/2008 3:30 PM-12:00 AM 0.5714
Now, I need to have it look at the dates that are the same and out of those,the lowest reliability should get the overtime. For example (1/2/2008, 2 entries, 0 Reliabilty should get Overtime).
Does anyone know of any function that would allow me to get this result?
Any help appreciated!!!!
Without knowing more about your table structure, the only thing that i can suggest is that you can use one of the functions within your query to simply sort all results that you have by ASCENDING order by TimeStamp, and then Reliable and use the FIRST option on your Percent of Reliable field, then that would select from the query the First Item from the list that would match your criteria in the query without it displaying the duplicate people that are wanting the same schedule time.
If you're wanting it to calculate overtime, if that person has more time than they should, then I need more information about your table structure in order to answer than question.
Hope that helps,
Joe P.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Porky |
last post by:
Scenario: login/logoff scripts that kick username, times, and dates out
to a CSV file. I have a linked table in access pointing to that CSV
file. Users typically log in and log out twice a day (they are required
by company policy to log out when they go to lunch).
Problem: I am trying to figure out a way to check when they logged in
first thing in the morning. Certain performance bonuses are based on
whether or not they logged into...
|
by: Eric Whittaker |
last post by:
here's my dilemma, on the program below, i am trying to calculate overtime
pay at time and a half, but instead of only counting the hours after 40, it
counts all hrs at that rate, how can i avoid this? thanks.
// figures hourly wages for employees
#include <iostream>
#include <conio.h>
using std::cout;
|
by: Laura |
last post by:
Here's the situation:
I'm trying to use an update query to copy data from one row to another.
Here is the situation:
I have 5 companies that are linked to each other. I need to show all 5
companies on a form. 3 of the companies have common employees. I have a
table that looks like this:
|
by: Jamie Pittman via AccessMonster.com |
last post by:
I am currently working on a project to take an employees time for a day and and if over 8 hours it would move those extra hours to overtime row amd not caculate into regular time. I started to use this formula but it is probably way off trak , for it is giving me an error stating that it will match to many records. ANYONE PLEASE HELP.....
Total Time in Minutes: DateDiff("n",,)/60
--
Message posted via http://www.accessmonster.com
|
by: Jamie Pittman via AccessMonster.com |
last post by:
I have two tables with 5000 entries on them. One is based for regular time
with several variables example (employee name, date,time in and out, code,
customer, building) I have another table that works with overtime but has
the same feilds within the table. I want to be able to run a report that
combines the regular time and overtime for the warehouse and seperated by
each customer. I have tried join tables but I keep ending with, (if it...
| |
by: SK |
last post by:
Hi
I am trying to teach myself how to program in C. I am a physician
hoping to be able to help restructure my office. Anyhow, I amhoping
that the porblem I am having is simple to those much more experienced
in programming. I am trying to use the concept of arrays to calculate
the hours of my backoffice staff, however I am getting a ridiculous
amount of error lines. If any one has time to help me that would be
great. I am using the...
|
by: SK |
last post by:
Hi
I am trying to write a simple C program with devc++ as the complier
using the concept of arrays. I cannot get the program to compile
without mutiple errors. If anyone has the time to help me I would
really apprecaite it.
Thanks SK
//Specs to be added later
//C Libraries
#include <stdio.h>
|
by: D |
last post by:
Hello all...I have an issue with one of my java script functions that
I'm hoping someone can easily help with. I have a web based application
that we use to create/sign up for overtime. When we have holidays we
require our employees to sign up in 4 hr increments for the times we
post. I'm having trouble creating a time slot that ends @ 12am. 12pm
and all other hours work fine for start/end times. however 12am causes
problems. My actual...
|
by: cori25 |
last post by:
I have 4 database's that I need to enter and run a macro in. The macro in each db is named the same. I am having difficulty creating a loop to go into one db run the macro exit and then go into another db run the macro exit, etc...
Any help appreciated
Function Delete()
Dim DbPath$
Dim intMacro As Integer
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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: 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.
| |