I have an Access application that calculates elapsed time to the second. It works fine with a format of hh:nn:ss and input mask 00:00:00. Now the requirement has changed and I am required to do these calculations to the tenth of a second. As far as I can see Access doesn't accommodate split seconds. I realize I could put the split second time into another integer field but this makes calculations complex.
I am running an Access Database for a large uk companys call centre.. I use many diffrent systems which allow me to show our centres productivity...
I have hit a wall
When i first developed the DB i used the time formatting hh:mm:ss but later down the line i found if you *the time by 86400 it converts the hh:mm:ss into a workable seconds format....
One of my old extracts that i feedinto the DB are in the old format therefor i do this calculation within an access query which *the time by 86400
however i have found an probelm.. if the time is over 24hrs it seems to double the time there or there abouts in seeconds
example
01/01/1900 01:42:00 which is basically 25 hrs should be around 92520 seconds
when is do this calculation in an access query it is coming out 178920 all the other times are correct so this rules out how i link 2 querys ....
Here's one that I'm having difficulty on. I know just enough about code to completely confuse myself, so if you answer this, please explain in detail. I have a training database, in which a portion of it stores the scores of events of a physical fitness test. Part of this test is a times 3 mile run. I need to calculate a point value for the submitted time, but here's my dilema...If I use the time/date feature it accepts the input as hh:mm, and will not let a time of more than 24 minutes be entered, since it sees this as 2400, or midnight in military time. I need the data to be inputed as mm:ss, and I have another text box that accepts this info and converts it to a point value. I would appreciate any help you could provide. Thanks in advance.
I am what you would consider an extreme newcommer to Access. I used to use FileMaker as my database app. I have a bunch of data in an excel workbook that now needs to be converted to DB and I want to use Access.
I have the form set up and I have a bunch of time fields entered in minutes and seconds. They show up as 12:05:32 AM. I want this to display only as minutes and seconds (5:32) drop the hours and am. Is there a mask I can use or how would I approach this?
I am writing an Access program to compile Cell phone billing information for my company that has around 60 phones. I am entering the detail information and reporting on it. The problem I am having is with the minutes and seconds calculations. For instance employee A might have accumulated 630:59 minutes for the current month and employee B might have 250:12 minutes (Mins Secs) for the current month and so on. I want to be able to enter these amounts in a feild and then be able to sum them. Can you tell me how to format the field that the detail minutes will be entered into. I have been looking on the net for hours for a solution. Also I want the sumation to be formated in minutes not hours. Example
630:59 540:12
Would = 1171:11 If this is possible, what would be the field data type and format.
ok.. i am storing CD info in a database, including track lengths, these are obviously in minutes and seconds.. I cant use short time because that is hours and minutes, which means any track longer than 24 minutes doesnt work.. i cant simply use text with an input mask because i want to be able to calculate the total length of the CD by adding the track lengths together.. if i use Long Time it also shows hours, which will confuse the user, and create more scope for errors.. any suggestions? I hope I am making sense here.. thanks for any suggestions :D
This must have been answered before, but I can't find it by searching so sorry for the dumb question.
I input a time in hours and minutes in a field with a Short Time format. I would like then to convert this to seconds in a field with a number format so that I can total the seconds and then add them to the results of a calculated DateDiff control to get the grand total of time spent on a project.
Basically, I get daily reports from the client and the AHT and ACW values come in seconds. I've recently added code to the query changing the data to nn:ss which works perfectly. Below is some info:
tblTelephony [AgentName] [Calls] (number of calls answered) [AHT] (in seconds) [ACW] (in seconds)
[Code] ....
The above code works very well, where I'm stuck is in the attempt to average the fields [AHTMinSec] & [ACWMinSec] by Agent in a report.
Using [AHTMinSec] as an example:
I have the daily values for each agent [AHTMinSec] in the detail, Avg([AHTMinSec]) in the Agent group footer showing each agent's average, Avg([AHTMinSec]) in the Team group footer showing team averages and Avg([AHTMinSec]) in the report footer showing the campaign average including all teams. When I run the report the details are hidden providing each agent's average, the team average, and the campaign average.
The report worked just fine until I converted to minutes with the above code. Is there a reason that I'm getting an error stating that the calculation is too complex? I've done enough research to determine that the db can't Sum in order to average...
I want to call commandbutton1,2,3 after every 10 seconds automatically but following code doesn't do that.
Code: Private Sub UserForm_Initialize() 'Update the Barcodes printed today Call CommandButton1_Click 'Update batches to be scanned / batches scanned today Call CommandButton3_Click 'Update files batched and counted today Call CommandButton2_Click Application.OnTime Now + TimeValue("00:00:00"), "GoToSub" End Sub
I am currently working on a database where my source data has the times in military format which includes the seconds; 18:45:30. All my time fields are set to data/time and format is Short Time. The Short Time format gives me military time but only down to the minute. I need to include the seconds into my time fields. I tried creating an input mask but it converts it to standard time.
how I can show military time down to the seconds as in my example above?
I am working on making a DB to use as a production schedule. tblBuilds holds a list of builds. I have several reports to show this list with different filters. One such report is rptBuildsToday. This report will be open on the production warehouse computer and displayed on a huge screen all day every day.
Is it possible to make it so this report auto runs again every so often? When new builds are added to tblBuilds, or if a record on the table has its date changed to "today", It would be nice to have the report reflect this change within a certain time without having to manually refresh the report. The people looking at the screen will be doing so from their work benches and nowhere near the computer that has it opened.
If this is indeed possible, could the proposed method also work on a report or form inside the tab of a navigation control?
One of the directors of the company I work for would like to have a large screen display the current status of jobs that my database stores. To cut a long story short the table he is interested in is called tblJobsLogging and is updated manually by our laboratory on a regular basis as jobs are completed using a form linked to a query in turn linked to that table.
Think fast food chain order monitor. He wants to be able to look up from his desk and see the progress directly in front of him at any point.
Is there any way that I can have an access form displaying these records in a datasheet view which continuously refreshes every X seconds / minutes or updates as a record is updated in the underlying table?
I am using the calender control 11.0. By this calender I can only set the date year, month and day. I can not set the clock time:Hours, minutes and seconds. Is there a calender that enables me to set the date in the format:dd-mm-yyyy HH:MM:SS, means day,month,year Hour:Minutes:Seconds.
I have a table with 2 coloums with nuberin them. I would like to add those 2 number together and display them in a 3rd coloum. I need to automatically change the 3rd coloums value should any others change. Is this possible?
age: DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))Dob is stored yyyyddmmI thought this above function looks ok. When I run it, I get a data type mismatch in criteria expression.What am I missing?Any help would be appreciated.Thanks
in the subform i have 2 fields: duur and subtotaal in duur i enter a number. in subtotaal a calculation has to occur: =20*([duur]/60) i tried to do this calculation in VBA but then i got the same value on every record in the subform.
But now the problem: in the mainform i have a control 'totaal' that needs to do a DSum of subtotaal. And here i am getting into troubles since subtotaal is not stored in the table but calculated.
The formulla for DSum would be: Me.Parent!totaal = DSum("subtotaal", "tblFacturenDetail", "[FactuurID] = " & Me.Parent!FactuurID)
Hi. I am trying to creat some sort of security for my database so none else make changes to design of the database apart from me. I have got a small database that i run on the company network i work for. all the staffs have a short cut of this database on ther desktop where they can add/edit/view data and unfortunatly able to change design of the database if i havent set the startup to only show switchboard. what I want is this:
Open database, switchboard popup and nothing else(ie. database window where you can see table,forms,queries)..sounds simple..but havent able to do it..
people say use database split...not so sure on...by the way, I DONT WANT OTHER USERS TO HAVE PASSWORD TO ACCESS THE DATA...hint,,no password and user name popups....
i am kinda new to access,,pleeeeeeeease help
Hi. I am trying to complete my access database by creating some security for it. I want to know how to setup the database file so when I execute, let say in my document folder so that when it opens it only shows my switchboard and not the editable(table,queries...) panel on the left hand side. I know i can hide it via the startup option but I want to completly blocking it so it doesn't allow any user to edit the design of the database. If anyone can help I realy appreciate it...thank you
I know that this might be extremely obvious to most people, but at the risk of sounding stupid I'm going to ask it anyway. I plan to share my split DB over the network. I know that the BE will be hidden from the view of most people so they won't try to meddle with it, but which would be better for the FE, should it be accessed by all of the users, or should they each create their own shortcuts, or does it even matter?
And I want them to have them linked so that no one else can have the same time in the court.
For example:
I booked the morning (AM) in a court for today (21/2/08). Somebody may want to book for the same day and can do so BUT he/she can only booked for the afternoon (PM) session of that day.
I am designing a new database for our life and disability department and they have several different policies where the base life insurance reduces at certain ages.
Please take a look at the scenarios listed below and give me any suggestions and tips on the best way to get this done. If you have any.
Below are the 12 scenarios:
1.) Reduces 75% at Age 70
2.) Age 65 to 70 the life amount is $9,000 and Age 70 and over the life amount is $6,000
3.) Reduces at age 65 by 92%, age 66 by 84.64%, age 67 by 77.869%, age 68 by 71.639%, age 69 by 65.908% and age 70 and over by 40%.
4.) On the day following the 70th birthday, the life amount will reduce to 70%. On the day following the 75th birthday the life amount will reduce to 40% of the 70th birthday reduced amount.
5.) On the Policy Anniversary Date following the 70th birthday - reduces 50%
6.) On the Premium Due Date following the 70th birthday, the life amount will reduce to 70%. On the Premium Due Date following the 75th birthday, life amount will reduce to 40% of the amount of the 70th birthday reduced amt.
7.) Age 65 life amount reduces to 65%. Age 70 life amount reduces to 35%. Age 75 life amount reduces to 25%.
8.) Terminates on the first of the month following the 65th birthday.
9.) Terminates Age 70
10.) Terminates on date of retirement or 1st or month following 70th birthday
I have a database containing values in 16 fields. the fields are filled in over a period of three years. I would like to be able to calculate the average of the last four values entered, regardless of when in the cycle the value is required. I have tryed to use quereies but connot find away to assign the four fields to the expression so that it is the last four values and if four don't exist, avearage what values there are.
I am new to Microsoft Access (2002) and the Access Word Forums. I am in need of a way to calculate timespent on six main topics through an 8 hr. working day. If I worked on Topic "A" from 8:00am to 8:15am, I need it to calculate it to 15 minutes. Then I need to figure a way to calculate how much time was spent doing Topic "A" for the working day, then by the workweek, then by the month.
I'm willing to learn, if someone has the time to teach or can direct me to a link that discusses something similar to what I am looking for. Any and all suggestions welcomed. I am looking forward to doing this in a timesheet format if possible.
Hi, I think this should be simple, but I am struggling to work it out
In a relational database I have a stock table containing stock and quantities, there is a customer table with an order table used as the link table also containing quantities.
What I am trying to do is place an order using an order form linked to the order table, automatically reducing the stock table by the amount ordered.
I have tried an update query with no success, also tried using the builder to make a query and linked it to the stock table with no success.
I would be grateful for any ideas, I am sure it is relatively simple
