i have a date field with time and date each record is entered. results look like this
Date_Complete
4/9/2007 8:26:11 AM
4/9/2007 8:31:25 AM
4/9/2007 8:34:14 AM
4/9/2007 8:34:21 AM
4/9/2007 8:34:29 AM
4/9/2007 8:34:36 AM
4/9/2007 8:34:49 AM
4/9/2007 8:41:27 AM
4/9/2007 8:41:49 AM
4/9/2007 8:42:32 AM
4/9/2007 8:42:39 AM
4/9/2007 8:42:49 AM
4/9/2007 8:43:36 AM
4/9/2007 8:44:21 AM
4/9/2007 8:45:48 AM
I want a query or report to give me the average entry time per record. Something like: Average time between orders 1:25 (one minute twenty five seconds)
I have a query with the fields dtDate (Date/Time in Short Date format), NC "Number of Chats" (Long Integer), and TCT "Total Chat Time"(Date/Time in hh:nn:ss format) from tblChats. Each date will have multiple NC and TCT values. This query is totaling them by date with the following SQL.
SELECT DISTINCTROW tblChat.dtDate, Format$([tblChat].[dtDate],'Short Date') AS ChatDate, Sum(tblChat.TCT) AS SumOfTCT, Sum(tblChat.NC) AS SumOfNC FROM tblChat GROUP BY tblChat.dtDate, Format$([tblChat].[dtDate],'Short Date') HAVING (((tblChat.dtDate)>=Date()-7)) ORDER BY tblChat.dtDate;
The query works fine. Now my question.
I would like the query to figure the average time per chat for each day.
We sell products out of vending machines and once in every few days (time span between readings may be different every time) read data from the machines using flash drive. Each reading from all machines produces an Excel file:
The only date that we have is the day on which the data has been read and this tells how many sausages were sold from the date of last reading till the date of current reading (after each reading counters are set to zero).
The problem is to get average amount of product X sold from machine Y on every calendar day. For a total rookie like me it seems like creating another column that would divide the Amount_sold by the number of days between two consecutive readings and put this average amount for every calendar day between these two readings. May it be done this way? How? Another way? How? I would be very grateful if anyone could help me and explain the solution in an accessible way.
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 have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.
The link works fine but the time formats are different.
On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format
However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#
Weirdly though, when you just open the table, the times are in the correct shorttime format.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
I apologise for my ignorance, but I’m very new to Access.
I have a database of dates, that I need to analyse.
I have created a Form called "DateRange" with 2 date fields; Text1 = Date From Text2 = Date to Command1 = Preview Report
My Query has 2 fields; Slotdate = all the dates (show as 20051210) Actdur = Actual Duration (show as numbers 1 or 12 or -3 etc)
The SQL View is; SELECT slotapp.slotdate, slotapp.actdur FROM slotapp WHERE (((slotapp.slotdate) Between [Forms]![DateRange]![Text1] And [Forms]![DateRange]![Text2]));
I just want to calculate an average of Actual Duration So that my report displays the average duration between the date ranges.
Any assistance in this matter would be greatly appreciated
Could someone please tell me how to work out the age of someone using a query or report and the average age of everyone?? I also need to know how to put on a report the total number of people satisfying the search criteria. It also says i must obtain a single record for each person and to do this i need to change a query property to allow only unique records to be displayed? do u know what this property is?? Please help!! Thank You
I have a customer concerns database that contains the dates for when the concerns were reported and tyhe dates for when the concerns were resolved. I am trying to make a query that finds the average of how long it takes for the concerns to be resolved. How can I do this?
I'm trying to create a query that returns 10-min average wind speed.
I have the logging date,time and the wind speed per second in the wind log table. Date and Time Wind Speed(mph) 28/04/2006 2:17:01 PM 10.5 28/04/2006 2:17:02 PM 10.6 28/04/2006 2:17:03 PM 10 ...
And I would like something like this from the query: Date and Time Wind Speed Ave 28/04/2006 2:17:00 PM 10 28/04/2006 2:18:00 PM 7 28/04/2006 2:19:00 PM 5 ......
I need to make a query which counts the number of days between "Date of Complaint" and "Effective Date". This is what I have so far:
[SELECT [Customer Complaint Log].[Complaint Number], DateDiff("d",[Date of Complaint],[Effective Date]) AS Expr1 FROM [Customer Complaint Log] WHERE ((([Customer Complaint Log].[Effective Date]) Is Not Null) AND (([Customer Complaint Log].[Date of Complaint]) Is Not Null));
I need to make it so that it uses todays date for "Effective Date" if there is no "Effective Date". Any help would be appreciated. Thanks.
I am running a query that returns the minimum, maximum, and average mileage of a list of cars. I have set decimal places to zero in all places I can think of, but of course the average returns with a long decimal output. These figures are then displayed on a report.
How can I truncate the 'average' display so it rounds to show no decimals?
I have tried using Round([YourNumberFieldName],3) in the query but that doesn't seem to work.
The numbers are stored in a table as double numbers. Again the decimal places are set to 0.
I have a file with hundreds of home builders. It has three fields for this problem. Table = Permit field = Per_date (Date Field) Date BLD record appears in table. field = BLD (Char) Builder number or Name field = SQFTArea (N) Size of home.
1. I need to be able to get the average for (SQFTArea) for all records greater than 950 (SQFTArea). 2. For year 2007. 3. Grouped by Builder (BLD).
Example: Per_date - BLD - SQFTArea Record: 2006 - 012 - 0500 Not becouse of 2006 and 0500 Record: 2007 - 012 - 2500 Record: 2007 - 012 - 3500 Record: 2007 - 058 - 2000 Not becose of BLD=058 Answer is for 2007 BLD 012 has an average of 3000
BLD 058 would be figured with it's self at average=2000 if the only record with this number or used with any other records that are BLD 058.
I have asked for help in the past but must likely my examples not that great. Here’s hopping. Hopping?? I hope I got that right being as I'm not a rabbit. Spell checker no help on this one.
First of all I consider myself to have Intermediate knowledge of Access. I am comfortable building tables, queries, reports, macros, etc. but get a little lost when needing to manually code something in a query.
I need to create a database to document quality reviews of certain reports the plant creates. Typically each report gets reviewed by 2 to 6 people and each section is scored. So lets say the database table has the following fields
I need a query that will average each of the Section Scores and Total Score so I can build a monthly report showing the report and the average grade for each section and the average total grade.
I need help with a calculation in my form. I have a form named families. IN this form I have 12 check box's, one for each month. I would like to set up another box which would take the average of the past 3 months and tell me what percentage of the time the box is checked. For example, since it is december, I would like a box named quarterly average to look at the past 3 months, obviously september, october and november, and tell me in percentages what the percentage is that the past 3 months check boxes have been checked. This is the basic code which I created for my unbounded box, but I want it to be dynamic, so that it recognizes what the month is today and tells me automatically what the percentage is.
Control sourceis set to =Abs(([Sep]+[Oct]+[Nov])/(3))
I am looking to calculate a simple average of two numbers when my form loads(It appears to be a basic concept, but I cannot figure it out). I have tried to build an expression but this didn't show any value. =([score1] + [score2])/2 I have attached my db to view my problem. I am wondering if anyone can assist me with this.
Hello, I have a querie that calculates the average of two sets of times taken from a calculated figure in a table. My problem is that the returned value seen when the querie is ran needs to be of a clock format. Eg 0.75 needs to read as 0:45 I have attached a Database to help, as i am unable to do this. Any suggestions given i am greatful for.
I apologize, I know this has been covered. But I just spent half an hour reading old posts and still can't quite decide how to apply it to what I'm doing.
I have a db that logs surgeries and all their details. One of the new things they want to do is be able to run a list of average cost for a certain surgery, since patients are always asking ahead of time how much it will cost. I have a query (and report that runs from it) that will list all the surgeries and total charges for individual ones for a date range the user specifies. But I can't figure out how to make it calculate an average charge for each surgery. I could if there were always a certain number to divide by, but of course there could be 2 of this type of surgery and 57 of that type.
