Changing the Number Format

I build a query using vba,
then i want to change the number format in some of the columns.
may i know how to achieve that?
thanks in anticipation.

my code is not working...
RecordSet("Income").NumberFormat ="###,##0"

If you are not using them in other things perhaps:

Code:

---

select blah, format(blahnumber,'%,000.00') as newblahno
from tblBlah

---

will suffice.