Time Difference Calculation
I am in middle of a development process and i am stuck. This is the situation:
I have three fields 1. StartTime, 2. EndTime, 3. TotalHrs. I can find the diffence using DateDiff('s',[StartTime],[EndTime]) in control source property in the TotalHrs. Fields StartTime and EndTime are bound to a table and TotalHrs is having this expression in the control source field. The value displays correctly in totalhrs. However, I am not able to store the TotalHrs value displayed in the underlying TotalHrs field in the Table.
I hope i have explained the situation. All i want is the value to be calculated in totalhrs and stored. I know a bit of VBA but not able to do this. I am using Access 2003 and VBA.
Any help would be greatly appreciated.