Root Cause, Preventative Action : Need time and Date Help.

[tokyojo1]

Hi Guys.



Relatively new to access, I just created a db for root cause preventative actions, what I am wanting to do is have the scheduled date/time field calculate the time in hrs and minutes a job was supposed to take, if the job doesn't get made on the scheduled time and day I have another field with actual date/time that I would like to be calculated.
There are also set up & clean down field that I would like to add to the actual time it too to run the job.

How would one go about this, I have read multiple posts, but apologies I cannot figure this out.

Anyone that can help, please make it as simple as possible for me to understand.

Appreciate help and advice..

[June7]

Use DateDiff() function. http://office.microsoft.com/en-us/ac...001228811.aspx

To get decimal hours:

DateDiff("n", [datetime start], [datetime end]) / 60

[tokyojo1]

Thanks, I kinda figured the datediff function out, cant seem to get the last part to calculate "There are also set up & clean down field that I would like to add to the actual time it took to run the job" =[Actual Run Time]+[Set Up Time]+[Clean Down Time], but i get a name? error..

[June7]

That usually indicates misspelling of field name or textbox name in the expression. Or the field is not even included in the form RecordSource.