Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313

    Unanswered: Remove decimal in report

    Hi all,

    I have a formatting issue I need help with. I'm designing a report which will be printed on a pre-printed form. I'm forced to use the pre-print due to insurance co requirements (they scan the form).

    Basically, it's a list of itemized charges. The charges cannot contain decimals or $.

    So $999.99 must display as 999 99

    I've tried "=Str([Line1Charge])" then several custom formats, but I can't seem to get rid of the decimal.

    I must be retarded. Any suggestions are appreciated.

    Chris

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You could pull it as a string and replace the decimal with a space using Replace()
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    Yep, I'm retarded today.

    Thanks Teddy.

    =Str([Line1Charge]*100) worked too.

Posting Permissions

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