Formatting Dates

[godzawilla]

I have a date that is coming into access from an ODBC connection from an AS400 server. It comes into access in the following format. YYYYMMDD example 20021210 for yesterday. I need to format it to print out as follows:
MM/DD/YYYY. it is a text field. I attempted using some basic SQL to format the date but am having no luck. Any help would be greatly appreciated.

 

[rac2]

SELECT Left(txtDate,4)+"/"+Right(txtDate,2)+"/"Mid(txtDate,5,2)
FROM MyTable