SantasLittleHelper
Board Regular
- Joined
- Nov 25, 2016
- Messages
- 77
I have a field with the expression below: (I've made the fields generic so they are easier to understand)
This table hopefully summarises what is currently happening:
<tbody>
</tbody>
Is there a way to format the Calculated field so that if the ID Number is used it, keeps any leading zeros?
Code:
IIF(Field1='Example Text',[IDCode] & [IDCounty],[IDCode] & [IDNumber])
This table hopefully summarises what is currently happening:
Field1 | IDCode | IDCounty | IDNumber | Calculated Field | What I want |
Example Text | AB | Cambridgeshire | (Null) | ABCambridgeshire | ABCambridgeshire |
Different Text | GH | (Null) | 00023 | GH23 | GH00023 |
Different Text | PI | (Null) | 00467 | PI467 | PI00467 |
<tbody>
</tbody>
Is there a way to format the Calculated field so that if the ID Number is used it, keeps any leading zeros?