Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    York, Pennsylvania, USA
    Posts
    164
    Thanks
    0
    Thanked 3 Times in 2 Posts

    Convert fixed number to text (Access XP)

    Got a dumb question.

    I've got 3 Access fields. the first and second are fixed, two decimal. I want the third field to be the difference between the first two fields, converted to text, yet retain the fixed, two decimal format. I've tried Cstr(field1 - field2) but that drops the trailing zero if the result is nn.10. Thanks

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert fixed number to text (Access XP)

    All you need to do is format the results...

    Try this: Difference: Format(CStr([field1]-[field2]),"Fixed")

    HTH
    P.S. There are no dumb questions silly! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    York, Pennsylvania, USA
    Posts
    164
    Thanks
    0
    Thanked 3 Times in 2 Posts

    Re: Convert fixed number to text (Access XP)

    Thanks, Trudi. That worked fine. Guess I'll stick to VBA for Word.

Posting Permissions

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