Access: Calculating number of work hours

[ReiJe]

Hi there,

I'm working on a database to track changes to a project. I have fields for EstimatedStartDate and RequiredCompletionDate and would like to automatically populate a Duration field with the difference in working hours between start and completion. Is this possible?
(Go easy on me - I'm pretty rusty!)

 

[kjv1611]

Is this possible?

Yes.

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

http://www.techonthenet.com/access/functions/date/datediff.php

http://www.blueclaw-db.com/visual-basic-function/vba-function.htm

Use info from there to take care of it with VBA code behind your form.

If you need more detailed answers, or have more specific questions, post them over at forum705.


--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

and you might get better responses, posting in one of the MANY Access forums, like forum702.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}