I have a report in VB using the DataReport Designer, linked up to an Access 2000 database. In one of the tables I have a numeric column that has a number representing a quantity of hours (eg 3.25 = 3 hours 15 mins).
My problem is I want the report to say 3 Hrs 15 Mins, not 3.25.
Any ideas would be appriciated, I dont want to alter the format of the column that holds the Hours, but I dont mind adding too the database if there is a way it can be done through linking.
Thanks In advance