Code:
SELECT Table1.accountID, string(8-len(FormatNumber([ref1],3))," ") & FormatNumber([ref1],3) AS Expr1
SELECT Table1.accountID, string(8-len(FormatNumber([ref1],3))," ") & FormatNumber([ref1],3) AS Expr1
SELECT Table1.accountID, string(8-len(ref1)," ") & [ref1] AS Expr1,etc, etc
Leave a comment: