How can I format output of SQL query

[Ben2k]

SELECT SUM(Profit) FROM Query1

How can I format it to currency/2 decimal places, its going into a listbox which doesn't seem to have any formatting options

Thanks

 

[Joe4]

Try:

SELECT FORMAT(SUM(Profit),"$0.00") FROM Query1