How do I convert "yyyymmdd" to "mm/dd/yyyy via a query

[DZ]

How do I convert "yyyymmdd" to "mm/dd/yyyy" via a query. I cannot change the
field properties in the table.

 

[Klatuu]

What is the data type of the field your working with? A Date/Time data type
does not present in yyyymmdd format?

 

[DZ]

Thank you for responding but I finally figured it out.

 

[scubadiver]

It is worth posting what you did. Then others who have similar queries can
find the answer easily.