david30120

Format and Field Calculate (Desktop 10)

Discussion created by david30120 on Apr 19, 2011
I have a two numeric fields (da & ds) that will have either one or two digits each. I need to make each a two digit number by adding a leading "0" to the single digit #'s then concatenate these into a four digit field. I have tried the following (the one I was using in Access) but fails.

    =Format([da],"00") & Format([ds],"00")

    Another option would be to format each field (DA & DS) individually then concatenate, but that fails as well. Is there another function to FORMAT?

Outcomes