SQL Round to 2 Decimal Points?? - Access World Forums

Hi Daniela - The formatting is something separate from the SQL statement. In the design view of the query, right click on the [CountofStudent Attended] field and select Properties. Set the Format item to Fixed and then the Decimal Places item to 2. hope t

www.access-programmers.co.uk