From your previous post:
SELECT Table1.date AS Expr1, IIf(IsNull(Table1.date),'','UP' & Format(1000*Format([table1].[Date],'yy')+Format([table1].[Date],'y'),'00000') & Mark) AS Date1
FROM Table1;
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244