Search results for query: *

When I do what you did above, I get no result in the text box. When I put the following into a query, I get an error result : DateDiff("Short Time",[TotDtTmOrdWrtn],[TotPtntFlr]) I'm not grasping your message unfortunately. Thanks for trying. Geoff

Thanks guys. Skip, I'm a bit dense on this. I've got, say, two bound boxes on the form, "OrdersWritten" and "PatientToFloor". I've done it so that they are in general date/time format as you've suggested (__/__/____ X:XX:XX AM). I want an unbound text box that subtracts the first field...

This is the code for the module used to calculate time differences. Because we have time differences greater than 1 day, I had to find a way to calculate elapsed times using "general dates." Here's the code: Option Compare Database Option Explicit Public Function HoursAndMinutes(interval As...

Your idea of querying a query is fine. These elapsed times are based on a string in a module, by the way. On a basic level, though, I'm unclear why I'm having trouble averaging values over a period of time. Forget the elapsed times for a moment (since those are date values). If I have 30...

I have calculated an average time using a module. The expression looks like this: Expr1: ElapsedTimeString([OrdersWritten],[PatientToFloor]) If I plug this into a query, I can successfully get the elapsed time for individual persons. However, I am looking to get an aggregate average. Yet...