Hours worked question

[chewy]

I am inputting hous into a DB as integers for acertain day
ie 03/07 7.5
06/12 4

The problem I encountered is that I need to in my report sort the date by cronoligical order, but some employees take two weeks off. It will take up too much room on paper to List all two weeks. What I instead want to do is be able to input the date as

02/25 - 03/05

I could do that with text I realize or an input mask...but the problem is it wont keep track of them in order of date.

 

[UKBobby]

What about having the two dates as separate fields. Therefore, the start date is either the day you wish to record hours against and the end date is only used to signify the end of the holiday period?


This will allow you to keep them in chronological order and allow the banding of holidays.

 

[chewy]

I dont know where the holiday part comes in

 

[kbrooks]

I believe holiday = vacation in this case.

 

[chewy]

What if is one day? I dont want to have to enter the same number twice

 

[UKBobby]

Where you are entering hours worked on a specific day you need only enter the date once, but where there is a holiday (vacation) period you enter the start date and the end date. Therefore your table would look like:

Date1.................Date2.........Hours
2 Feb 2003............................7
3 Feb 2003............................9
4 Feb 2003............................6
5 Feb 2003........9 Feb 2003..0 (or have a code specific to vacation)


On the report you could have both dates under a generic header (Dates) so that it fits if only one date is shown or two.

Do you see where I'm going with this?

Note- periods put in cause I couldn't figure how to show the table in columns - post system removed spaces - sorry