Adding Elapsed time

  • Thread starter Thread starter eb1mom
  • Start date Start date
E

eb1mom

I created a form using example from article 210604 Get
Elapsed Time. I am using this form to track building time.
Form works great. Now I want to calculate total building
time for any period a supervisor might select. I need to
add all elapsed times together. I have read many articles
in Knowledge Base but, can't seem to find this calculation.
Any suggestions for an example to look at?
 
Make the original calculation (for the separate build times) in a query
using a calculated field. Have the result as whole numbers or numbers and
decimals, not hours:minutes or days:hours:minutes. Use the smallest unit you
want returned (a smaller unit than this will work also) as the type of unit
to compute the value to (i.e. if you want hours and minutes, compute minutes
or seconds; if you want days and hours, compute hours or minutes). This will
give you a field that you can sum. Once you have summed the field, you can
format it as desired.

In the form, you may want to use the DSum function for the Control Source of
a textbox with the query as the Record Source and the calculated field as
the field to sum. In the query, you would have a parameter that refers to a
control on the form, such as the ID for the current job, to limit which
records are returned.
 
Thank-you for your quick reply. Looks like I have a lot to
work on. Current job ID parameter sounds good.
 
Back
Top