• Convert fixed number to text (Access XP)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Convert fixed number to text (Access XP)

    Author
    Topic
    #390337

    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

    Viewing 0 reply threads
    Author
    Replies
    • #692884

      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! smile

      • #692891

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

    Viewing 0 reply threads
    Reply To: Convert fixed number to text (Access XP)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: