I want to show work hours to one decimal in an Access 2013 query. My SQL statement is:
SELECT tblWorkRecords.WorkHours, Round([WorkHours],0) AS Expr1, Round([WorkHours],1) AS Expr2
ORDER BY tblWorkRecords.WorkHours DESC;
As seen in the example results, Expr2 does not show a single decimal as I expected.