I have a recordset with the following in it.
SELECT Quantity * Unit_Price + (Quantity * Unit_Price * Additional_Cost / 100)
FROM `material`
WHERE Job_No = 'colname'

This gives a result of 21.97452

How can I edit it to round up or down to two decimal places? such as 21.97 also to prefix it with a £ sign?

Thanks in advance
Paul