Dear sir,
I doing one school project in VB6 with Access database. here I use Data bound grid control for view. and I want know how to calculate hours in DBcrid pls help me.


Instead of simply using Sum, use this Query:

Select Sum(Val(MyDateTimeFld)) From MyTable

You will get total Time,
Later you need to get the Decimal Part, Integer Divide by 60, add it to Hours part, and keep the remainder in Decimal for Minutes..


Thank I apply this code now