Leading Zero missing

[darth sidious]

Hi

I have a query where I am geting the last 4 digits from an id. However my query when it returns the results misses out the leading zero from the results. For instance if I had an id of 12340567 the query should return 0567 but instead it returns 567. This is what I am using:

Max(Right([Employee]![EmployeeNumber],4))

Any help with this would be greatly appreciated.

Many thanks

Darth

 

[pr2-eugin]

Try formatting,

Format(Max(Right([Employee]![EmployeeNumber],4)), "0000")

 

[JohnLee]

Hi Darth,

As your EmployeeNumber field is a numeric field leading zero's will always drop out unless you do something as per Pr2eugin post.

Lord Vader [The master has spoken. Lol ]

 

[darth sidious]

Try formatting,

Format(Max(Right([Employee]![EmployeeNumber],4)), "0000")

Hi

Thanks for this, it did the trick

Darth