Adding leading spaces to a field

[johnbr]

Hi All,

I'm very new to access...

How can I add dynamic leading spaces to a query field? Essentially, I need to look at a trimmed field, and then duplicate it. However, the string needs to always have 10 characters. If the value is 405, I need 7 spaces in front of it. ' 405'

Something similar to:



if len([q_LPP.Item]) <= 10 then [q_LPP.Item] + space(10 - len([q_LPP.Item])) else [q_LPP.Item]

Thanks for your help.

John

[aytee111]

If it is always numeric then you can change it to a number which will do that for you.