Another Department created an Access Database. Rather than using a Date field in their table to hold date information for records, they set the data type of the field to number. They have over a 1000 records in the table already and now want to run queries against the data based on dates--which are stored as numbers. Is there an easy way to convert this number field to a date field without losing data. I tried just changing the data type on a copy of the table, but then the date information gets fouled up. Any help is appreciated.