Pivot Table Format number

[Jose]

I'm using an adp access 2007.
How can I format the number to2,000,000 (without decimals and with comma for
thousands)?

Thanks for any suggestion

JCP

 

[Wayne-I-M]

Hi

In the table design, set the number
Field Size = Single
Format = #,###

 

[Jose]

Thanks Wayne,

I'm using adp access file, so the back end is SQL Server. With adp, we can't
use format(number, "#,###")

If you have any suggestion, I aprreciate

Thanks,
JCP