I have a Table in Access with an Issue Date field that is all Text Data. The data appears as 100189, 092305, 020198, 123105, and 10200. I need for this data to have slashes in between the numbers so that Access will know that this is a Date/Time field instead. I want to query this tabel pulling records for a certain time-frame.
I know that an Update Query can be made to do this using SQL, but I am new to SQL and I need all 15,000 records done with MM/DD/YY.
Is there some SQl Code that will do this?