Question General DB Date Question

[Docara]

Hello and a Merry Christmas to you all

As per my introduction post - I'm working on yet another attempt to learn Access.

I'm planning a Job Sheet type DB for work as a focus to 'get inside' the logic of the programme and hopefully produce something that could be useful.

My question is, with minimal code (if any) what would be the best way to implement a duration/worked hours type facility facility when it is not known (until the work is completed) how long the job had actually taken.

eg 4hrs or say 3 days and 6 hrs

I was thinking of separate days of the week boxes and if they were filled in than obviously do a calculation or ideally possible use a calendar type control (start & end) to automatically show the correct number of fillable boxes.

Suggestion would be gratefully received

Thanks in advance
matt

 

[jdraw]

How about a WorkStartDate and WorkEndDate where each of these fields is a Date/Time datatype with a General Date format (includes Date and Time).

To get the elapsed time Use the DateDiff function
see http://www.techonthenet.com/access/functions/date/datediff.php
and Access help.

You may also want to review Normalization to assist with your database design.
Here's a link
http://en.wikipedia.org/wiki/Database_normalization

Merry Christmas and all the best in 2013!

 

[Docara]

Hi Jdraw,

Thanks so much for your reply.

Your link was incredibly helpful - because of it and the idea behind it I found a nice site which explained some other functions which will be of use AND easier than the MS helpfile.

(I miss the days you could take the BASIC manual to the toilet and read up)!!!!!

Cheers
Matt

 

[jdraw]

For the benefit of others, you might wish to reference that other site.

Glad you have it resolved.

 

[Docara]

As requested

techonthenet.com/access/functions/index.php

Not enough posts to enter as full link or URL - sorry but it hs the usual W's and http etc at the beginning!!!

Regards
Matt