Number to fixed length string

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

Is there a way to convert an integer value into a string of length 8 with
extra places filled with spaces? Ideally I need it done in single step as I
need to use it in a query. I have looked through str and string functions
but can't see anything relevant.

Many Thanks

Regards
 
It would have helped if you would have provided some samples so we would know
if you want the spaces before or after the number. Assuming before, use an
expression like:
Right(" " & [IntegerValue],8)
 
Back
Top