diff --git a/src/schema.sql b/src/schema.sql
index f213b2e..65db092 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -173,18 +173,18 @@
 --recorded by studentid
 create view report as
 select
-a.name as assessment, a.outof,
-s.studentid, s.name, s.usercode,
-cat.category, cat.sort_order as cat_order,
-cr.description as criterion, cr.max as max, cr.sort_order as cr_order,
-r.result,r.comment,
-round(m.mark,2) as mark
+	a.name as assessment, a.outof,
+	s.studentid, s.name, s.usercode,
+	cat.category, cat.sort_order as cat_order,
+	cr.description as criterion, cr.max as max, cr.sort_order as cr_order,
+	r.result,r.comment,
+	round(m.mark,3) as mark
 from assessment a
-join category cat
-inner join criterion cr on cat.category = cr.category
-inner join result r on r.criterion=cr.criterion
-inner join students s on cast(r.student as integer)=cast(s.studentid as integer)
-inner join mark m on cast(m.student as integer)=cast(s.studentid as integer)
+	join category cat
+	inner join criterion cr on cat.category = cr.category
+	inner join result r on r.criterion=cr.criterion
+	inner join students s on cast(r.student as integer)=cast(s.studentid as integer)
+	inner join mark m on cast(m.studentid as integer)=cast(s.studentid as integer)
 order by studentid, cat_order,cr_order
 
 
@@ -197,7 +197,7 @@
 	cat.category, cat.sort_order as cat_order,
 	cr.description as criterion, cr.max as max, cr.sort_order as cr_order,
 	r.result,r.comment,
-	round(m.mark,2) as mark
+	round(m.mark,3) as mark
 from assessment a
 	join category cat
 	inner join criterion cr on cat.category = cr.category