Date/time in Ms. Access is just a double. There are a number of functions to add date tyoe info - but these are just convient shorthand for the underlying process of refering to "Days" as the integer portion of the double, and using the fractional part to refer to the time. Ms. Access haas NO actual time type variable, so all uses of time alone are some type of "Kludge". You either carray along a "Day/Date" thing which is some ridiculous value, or just rely on you ability to manipulate the info youself.
Since the time portion is just 1.0 = 24 hours, 10 hours = 10/24 = 5/12 = 0.4166667 of a day, so you can just add this as a constant to your accumulated vacation on any occassion. As the time accrues, you will want to display it in a more useful format than is handily available. In general, take the accrued value * 24 to get the hours (and fractions of an hour. Obviously, many other display formats are possible, this is just to give you the concept.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over