Totalhours to Fractions

[desireemm1]

I need to the TotalHours to Fractions how do you do that in access

SELECT [Message Tracking].[Date & Time Left], [Message Tracking].[Date Returned], DateDiff("h",[Date & Time Left],[Date Returned]) AS TotalHours, [Message Tracking].ID
FROM [Message Tracking]
GROUP BY [Message Tracking].[Date & Time Left], [Message Tracking].[Date Returned], [Message Tracking].ID
HAVING ((([Message Tracking].[Date & Time Left]) Between [Begin_Date & Time Left] And [End_Date Returned]) AND (([Message Tracking].[Date Returned]) Is Not Null));

[June7]

Representing a fraction is building a text string. Most developers build a VBA custom function.

Bing: decimal to fraction

http://bytes.com/topic/access/answer...-number-format

http://stackoverflow.com/questions/7...-to-a-fraction