Convert number to fixed length text field

[tpcervelo]

I imported an Excel sheet with a field defined as number/numeric. In my make table query I need to convert that field to a fixed 9 position field with leading spaces.
I cannot concatenate the field with a set number of leading spaces because the input field is not always th same size.
I have tried using different attributes of the Format function but no luck.
Any help or information is greatly appreciated.


thanks

[dsmacs]

Try

right(" " & [VariableNumber],9)


where " " is nine spaces and [VariableNumber] is the name of the field with the number you want to convert.

Cheers
Darren