Thousands separator

[BeataG]

Hi,

Could anyone help me and tell if there is thousands separator in Access, the same or similar as in Excel. I'd like to use it to one of the field in my query.

Thank you in advance.

 

[JANR]

Yes there is, In the property FORMAT of your queryfield change it to STANDARD.

JR

 

[BeataG]

Thank you
Regards

 

[JamesMcS]

You can copy the format from Excel if you like, then use it in code. If you go to custom format in Excel, the one you might want for this is #,##0, so say you wanted to format a text box:

textbox.value=format([fieldname],"#,##0")

 

[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

 

[JANR]

You could use format function, something like this:

NewPrice: Format([Price],"##\,##\,###\.00")

JR