Format numbers in union query results

[Dawnit]

Hi! Is it possible to have the results of this union query to return "001" instead of "1" when the underlying tables format property is "000"?

Thanks!!

UNION ALL SELECT [BoxID Prefix], [BoxID], [OldID], [Function], [Description], [SubDescrip], [Notes], [From#], [To#], [DateFrom], [DateTo], [SchedDestruc], [FY/CalYr], [Perm], [Image], [DateAudited], [DateImaged], [DateWrhsd], [DeptRet], [TotalRet], [DateDestroyed], [DestrucList#]
FROM [P/R Records]

UNION ALL SELECT [BoxID Prefix], [BoxID], [OldID], [Function], [Description], [SubDescrip], [Notes], [From#], [To#], [DateFrom], [DateTo], [SchedDestruc], [FY/CalYr], [Perm], [Image], [DateAudited], [DateImaged], [DateWrhsd], [DeptRet], [TotalRet], [DateDestroyed], [DestrucList#]
FROM [RDA Records]
ORDER BY [Function], [Description], [SubDescrip], [From#], [To#], [DateFrom], [DateTo];

 

[gcole]

You could assign it to a string and pad it with 0's.

 

[Dawnit]

Sounds good! How do I do that?