Calculating the average time between StartTime and EndTime in VBA or in a calculated control. Then getting an average for many records
I want to get the average time between StartTime and EndTime in VBA or in a calculated control. Then get an average for many records. I am using Access to build controls on a form that will show the average in the form-footer so that when a user changes the form filter the [AvgTimeOnSite] control will add up the [TimeOnSite] controls from above record sets and display an average of minutes that each driver spends at a particular plant when making deliveries.
I am looking to get the average time in minutes that a delivery drivers spend at a particular plant getting loaded or unloaded.
Solution
Use DateDiff("n", ReceivingTime, DepartingTime) to calculate the minutes spent.
Then use Sum and Avg in the form's footer as control sources:
=Sum(DateDiff("n",ReceivingTime,DepartingTime))
=Avg(DateDiff("n",ReceivingTime,DepartingTime))
- Multiple users working from same application through ODBC corrupt ms access DB file. What is wrong?
- c# Cannot open Database - Windows 10 Access 2016
- How to make a Report title dependent on a parameter?
- How can I get TSQL from easy MS Access SQL with little to no handiwork?
- How select query from record count more than 1 and count more than 2 with custom column (Option) in MS Access
- How do I sort "SELECT INTO" queries that are built on top of each other by their "INTO" / "FROM" table links?
- Access database not closing properly
- How to open form to specific record from datasheet
- MS Access Expression Builder Value from another Table
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- I'm getting an Error with my iff statement
- VBA "does not equal" code not stepping through IF statement as expected
- MSACCESS.EXE process won't end
- Adding an index to query result
- How can I make a search query disregard punctuation?
- VBA-Json Parse Nested Json
- Microsoft question regarding IIf statement or a better solution
- How select query from record count more than 2 with custom column (Option) in MS Access
- How do I enter a parameter to limit the results of a query using ADODB.connection & ADODB.Recordset using Excel VBA?
- How do I get my Mailmerge VBA routine not to show dialog box and to run automatically
- Sql TRANSFORM with calculation time in MS Access
- Dapper with Mapping by code: Multi-Mapping with repeating column names
- Finding a double quote character
- connected combo boxes in continuous form - the second combo doesn't show its value if dependent on first combo how could I fix that
- Passing DateTime.Now into Access database
- Why MS Access works with SQL server ODBC via internet so slow?
- Subform only shows single record
- Running Microsoft Access as a Scheduled Task
- Open form and get value from computed textbox
- How to query all the ID of the first table with the last Event and the first Date on the second table related one-to-many to the first?