I imported an Excel file into a table where the first field is a Text field (JobNo) that is left justified and can be either numeric or alphanumeric. In order to query against a legacy database I need to make sure the field is properly justified. If numeric then it needs to be 9 position space left filled such as " 12345". If alphanumeric then it can remain left justified such as "12345W". I know I can use Right(Space(9) & [JobNo],9) for the numeric field. I tried writing an Update Query using If IsNumeric but can't figure out the syntax...any combination I try returns a syntax error.
thanks for any help.