SantasLittleHelper
Board Regular
- Joined
- Nov 25, 2016
- Messages
- 77
I have a formula field in an access table which basically combines 2 fields. However, the calculated field changes the number field to remove the zeros. Is the below possible?
<tbody>
</tbody>
Letters | Numbers | What the Calculated Field shows | What I want the calculated field to show |
AA | 0001 | AA1 | AA0001 |
AA | 0002 | AA2 | AA0002 |
BB | 0001 | BB1 | BB0001 |
BB | 0002 | BB2 | BB0002 |
<tbody>
</tbody>