Changing the Number Format

[spoonjy]

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"

[Ecniv]

If you are not using them in other things perhaps:

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

will suffice.