SQL Query help on limiting decimal places

[Matt's Challenge.com]

Could someone reply inserting the code to limit the result to show only 1
decimal place.
Thanks

--
SELECT Registrant_Information.Gender,
(Avg([Date_of_Diagnosis]-[Date_of_Birth])/365) AS GAveDxAge,
(Avg([Walk_End_Date]-[Date_of_Diagnosis])/30) AS GAveDxWalk,
(Avg([Talk_End_Date]-[Date_of_Diagnosis])/30) AS GAveDxTalk,
(Avg([Eat_End_Date]-[Date_of_Diagnosis])/30) AS GAveDxEat,
(Avg([Breath_End_Date]-[Date_of_Diagnosis])/30) AS GAveDxBreath,
(Avg([Date_of_Death]-[Date_of_Diagnosis])/30) AS GAveDxLive
FROM Registrant_Information
GROUP BY Registrant_Information.Gender
ORDER BY Registrant_Information.Gender;

 

[Kathleen Anderson [MVP - FP]]

See the reply from Jim Buyens to your post in the client newsgroup and
please don't multi-post - thanks!