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?


[email protected]


Joel Carmack

Try this in the update to field - Assuming you are using the query builder...

LEFT([IssueDate],2) & "/" & MID([IssueDate],3,2) & "/" & RIGHT([IssueDate],4)



Mike
EchoVue.com

Sorry, the last digit should be 2, since there are only 2 numbers for the year.

Mike
EchoVue.com

Mike,

Thanks so much! It worked! I am new to ACCESS and SQL. I'm glad there are knowledgeable people out there. I am hoping I can get experienced like you.

It will take some time, but I feel that I can learn it.

Again, Thanks


Joel

Joel Carmack

Hi Joel,

Good to hear, and welcome to the forum. I don't know if I rank even close to being and expert, but leveraging the combined knowledge of everyone who subscribes to it, there will be precious little that you can't figure out how to do.

Mike


Mike
EchoVue.com