thousandseparator

[anil.kut]

i want the digit grouping as indian number i.e lakhs, crore viz 12,34,567.00 in access report

i am using access 2007 and regional setting for numbers already set to indian grouping.
it works in excel but not in access table/report.
help

 

[vbaInet]

Not sure about the whole Indian grouping thing but you could try using the Format() function.

 

[anil.kut]

format () function takes the british number system , though regional setting is done for indian one, moreover excel exhibts correctly

 

[boblarson]

Format puts whatever you put in it. You can use

Format([FieldName],"00,00,00#.##")

 

[anil.kut]

i tried but as soon as saved it turns format like 000,000.##

help

 

[boblarson]

I think you might want to look at this thread:

http://www.eggheadcafe.com/software/aspnet/35647872/converting-the-digits-to.aspx