Hi Guys,
Please help I am pulling my hair out here.
I am creating a small Data base in Access.
My one filed I want to formate it Hours and minutes ( ie 250 hours and 30 min ). I have used [h]:mm, but when i try capture it , its says wrong formate. I want to capture how long it has taken to do something ( hours & mintues ) and not as in time 22H45.
It works in excel [h]:mm but not in access. maybe i have to set something else in access.
Please can you help, thanks
vaughan
Please help I am pulling my hair out here.
I am creating a small Data base in Access.
My one filed I want to formate it Hours and minutes ( ie 250 hours and 30 min ). I have used [h]:mm, but when i try capture it , its says wrong formate. I want to capture how long it has taken to do something ( hours & mintues ) and not as in time 22H45.
It works in excel [h]:mm but not in access. maybe i have to set something else in access.
Please can you help, thanks
vaughan