I have a form where you can enter the work you did in a day,
There are many users, each entering data for a single date.
What I want my form to do is, when a date and name is picked (from 2 boxes on the form) it will bring up the record relating to that person for the day.
If there is no record for that person on the day, this will be the first data the person enters.
So for example the form Hours:-
name mcbiyms2 (combo box) date 05/05/06 (text box:- =Date() )
Work Type 1 [ ] Time [ ]
Work Type 2 [ ] Time [ ]
So if somebody has already enetered some data for that day, it will bring this up to add too, if not it will be a new record to be entered.
We are trying to find a way to have a query figure out when the hours of an employee reach 40 hours (Overtime) and figure the hours correctly. The Data Entry table contains the basic fields:
[Workdate].....The date the work was done [WEDate].......The Week Ending Date. Always on Sunday, and calculated like this "[WorkDate]-Weekday([WorkDate]-1)+7" [Employee].....Employee Name [Qty].............# of hours worked that day [RegHours].....Blank, to be updated by query [OTHours]......Blank, to be updated by query
The problem we are running into is getting it to update the daily running totals (using the [WEDate] & [employee] as the "Group Bys"). We'd like use an update query to fill in the to blank fields with the correct calculations.
Example - Working 6 day week, at 9 Hours per day in the [Qty] field
Any ideas on calculating future dates based on # of working hours. For example... If a task is suppossed to be completed in 32 business hours, when would that be? Considerations include standard working hours M-F, no working hours on weekend. I have to believe that someone has written this before and I don't need to reinvent the wheel. ANy help is much appreciated!
Before I jump in and start creating a way to record times worked I thought it best to ask for advice.
The db is created and the last part is to capture by member: Basically I have the following fields:
MemberID Job Type Date of Job Time Started Time Finished
From the data captured I need to create a report to show month and ytd hours worked.
It would be easy to ask the user to calculate the hours worked and input the number of hours, however I would like to capture start and finish times.
Can anyone give me any pointers on the best field types and field formats for capturing times which would then make it easier to work out hours worked.
I am using the now() function in my date_added field. My site is GMT based but my server is in the US and is returning the date added as 6 hours before which does not look good on the site ...
Is there a way to add 6 hours when the timestamp is being added ?( now() +6hrs ) for example...
Or can I add 6 hours to a time stamp on read back? If so how can I add this in clasic asp?
I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
Hi, I am trying to figure out a way to keep record of store hours, and days open for lots of different restaurants. The only thing I could up with is the following. I'm not sure how to keep track of store hours, or even the best way to make a table for hours. Any help is appreciated, thanks.
I've searched and searched to no avail to find the answer, hopefully you can help.
The story is:
At work, our holidays are now taken as hours off. For example...if I take a Monday off, its 8hrs and 5 min and a Monday morning would be 4hrs and 5 min...What I want to do is calculate how many hours I have taken off throughout the year.
The way I was going to do it was:
Create Table called Times,
Fields = Week, Day, Morning, Afternoon, Friday and 1hour all Data Type "Date/Time"
Similar field names Wk, Days, Morn etc. They would be Data Type "Number"
Now in my simple head, I thought I could simply record how many weeks or days off i had off. Then create a query (for example) Week*Wk to calculate the amount of hours I had off. In simple terms if I had 2 weeks and 2 days off, the query would multiply Week (37) by Wk (2) and Day (8:05) by Days (2), giving a total of 90 hrs and 10 min.
I know there is a datatype mismatch, but is there a way round this.
I have a query in which I need to display just the data that was entered from 9:00 p.m. the previous day until now. There is a date/time field called "QtyTime".
I have an access table, and there is a field called user_time. Once a user record has been inserted, it puts a timestamp on this field, to record the date/time the record was saved to the database.
Now I need to write a query to check if it has been 72 hours since the insertion of the user into the database. This will exclude weekends. If a record was inserted on a Friday, on Monday it will not be 72 hours, as weekends are not taken into account only weekdays. So Monday will only be 24 hours since the user was added.
Hi, I have been looking for some answear, but haven't find the proper one!! I have a form containing a number of records showing the hours worked in format HH.MM at the end of the form I have the sum of the hours, but the result is not correct. To make it simple to understand, actualy the total of hous for 11.55 and 11.14 gives me the result of 22.69 but the correct result should be 23.09 (23h and 09m and not 22h and 59m) How can I get the right total??? Marco
I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.
I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?
Looking to have a time field that a user can enter how long they worked an issue. Format should be ##:##, but I'm afraid that if I use text, calculations will be impossible. How does someone do this if it's expected that the value will frequently go over 24 hours?
Hello. I have this continous forms which gets data from a query. The query has a field that sums date(hours), and I want them to show more them 24, for example, 42:30.
If I use general number it shows something like 1.2303256 and if I use short date it show something like 02:00 for 26 hours.
If I use a simple code is shows the SAME value in ALL the continuos form.
Which code should I put at the forms field so it would work, that is, it shows a diferent short date in ALL the continous form?
I have fields that are time formated 99/99/99" "00:00;0;_ and I want to subtract them.
I need to get the results in two forms; first in Days and second in Hours. I have used the obvious subtract one from the other and it gives me days in a rounded numbeer, but the hours is not working out.:confused:
I have four date/time fields and I need to determine the number of days and the number of hours between them based on report date range. The Days need to be in one field and the hours in another field. I have tried DateDiff function with an IIF condition and get the following negative value in Expr1. If I remove the IIF condition then I get a positive value.
If the date in field 1 is less than field 3, the days and hours need to be calculated field 2- field 3 as long as field 2 is less than or equal to field 4. If field 2 is null and if the date in field 1 is less than field 3, the days and hours need to be calculated field 2-3 but if field 1 is less than field 3 the calculation would be field 4- field 1. When both dates are within the report range then DateDiff works fine.
Adm Date [/U](f1) D/C Date/Time (f2) Beg Report (f3) End Report (f4) Expr1
I could e-mail the table with sample dates if this would help Can anyone assist me with this formula?????:mad:
I want to create a query that will calculate the following:
When a user enters a start time and an end time in 2 seperate fields (eg. 06:00 and 08:00) I want to automatically return how many hours fall between 00:00 to 01:00, 01:00 to 02:00, 02:00 to 03:00 etc through the 24 hour clock.
To give you a background why I want this, I'm creating a labour planning database that calculates the nuber of people available each hour in a warehouse. So when a user inputs 06:00 to 08:00 for overtime work I need the database to tell me 1 hour falls between 06:00 to 07:00 and 1 hour between 07:00 to 08:00.
I'm really struggling to come up with a solution to this one, any help would be appreciated.
I need to calculate the difference between to datetime fields. However, i need to exclude weekends, holidays and non-business hours. I also need to return the result in hours, minutes, seconds.
can this be done. if so, does anyone know how to do this, or is there code that i can implement and save for future uses.
I have the following SQL to add hours SELECT tblTrip.PaySlipReference, Sum(tblTrip.NDays) AS TotNDays, Int(Sum(tblTrip.FlyingTime)*24)&"."& Format (Sum(tblTrip.FlyingTime),"nn") AS TotFlyingTime, Int(Sum(tblTrip.DutyTime))&"."& Format(Sum(tblTrip.FlyingTime),"nn") AS TotDutyTime, Int(Sum(tblTrip.TAFB))&"."& Format(Sum(tblTrip.TAFB),"nn") AS TotTAFB, Sum(tblTrip!DutyPayRate*tblTrip!TAFB) AS TotDutyPay, Count(tblTrip.NDays) AS NumberOfTrips FROM tblTrip GROUP BY tblTrip.PaySlipReference;
Refering to the part "AS TotFlyingTime" it works perfectly as the format is a 24h and never goes over 23.59 hh.mm. The problem I incour is a incorrect result for the other two parts of the code: "AS TotDutyTime" and "ASTotTAFB", these data have values over 23h59m.
4/11/2007 1:01:28 AM 4/12/2007 2:02:52 AM 4/13/2007 4:21:30 AM 4/14/2007 2:22:21 AM 4/15/2007 3:34:53 AM 4/16/2007 4:02:37 AM 4/17/2007 5:03:15 AM 4/18/2007 7:17:34 AM
I need helps again How can I subtract 7 hour from the query
Please tell me why Access and Excel are calculating the hours this way... The number of hours between 18:00 hours (6:00 p.m.) and 24:00 hours (12 a.m.) should be 6 hours. Access and Excel are both returning a datediff value of 18 hours. If I change the end time to 12 p.m. (12:00 hours), then Access/Excel returns 6 hours but midnight is not 12:00 p.m. nor is it 12:00 hours.