Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2002
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thousand Separator (2000)

    I am counting some records in a report and I want the numbers to show the "thousands" separator. Where do I turn this option on?
    Thank you,
    Doug Lowry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Thousand Separator (2000)

    Set the Format property of the text box to (for example) <code>#,##0</code>

  3. #3
    Star Lounger
    Join Date
    Feb 2002
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Thousand Separator (2000)

    Thank you, Hans.
    What if in the Report the text box control source is: ="Summary for " & "'Gender' = " & " " & [Gender] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"?

    Doug

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Thousand Separator (2000)

    In that case, you can use the Format function:
    <code>
    ="Summary for " & "'Gender' = " & " " & [Gender] & " (" & Format(Count(*),"#,##0") & " " & IIf(Count(*)=1,"detail record","detail records") & ")"</code>

  5. #5
    Star Lounger
    Join Date
    Feb 2002
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Thousand Separator (2000)

    Thank you, Hans. That's terrific.
    Doug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •