Issue with thousand Separator

  • Hi,

    I am working with some data + string.

    Example: 2000 EUR where i am getting the same from different -2 columns (2000 from one column and EUR from different). and combining them in string format. Now i want to show numeric field as thousand separator like 2,000 EUR.

    Please help.

  • =Format([Value Field],"N")&" "&[Currency Field]

    That should do it - the format function is great for controlling individual items inside a larger composite.

    Info on the number codes is available on the BOL, although be warned that because it's using the .net framework the examples etc are all geared around coders

    http://msdn.microsoft.com/en-us/library/dd220510.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply