Thanks will try to concatenate the #. I am good with storing data as either numbers or text - whichever works. As the source table is via ODBC, I can not change. The only workaround I know would be to create an non ODBC table with a date formated field and write a delete / append query - which I am better off posting in a separate thread.