time calculations

[venu]

I have a table having hours field. how to give format to this field as HH:MM. I want to enter in this field time period like 01:59 (one hour and fifty nine minutes) and like 25:30(twenty five hours and thirty minutes). i want to add this time period in another field. please help me out. my database in much depend on this time period.

[RuralGuy]

DateTime fields are an actual DateTime value and not an "amount" of time. Use two Integer fields for the Hours and Minutes and then you can put them together when needed. You can easily use the Split() function to separate the entered value in the BeforeUpdate event of the control. You could also use a Text (String) field and do the separation in the AfterUpdate event of the control. Regardless of the method, you will need to programatically keep track of the Hours and Minutes separately as Access does not help in this area.