Date from imported data

[Lee]

I am new to Access and need to create a date from 20100207 in a query that I
am making. In Excel it goes Date(left(),mid(),right()) to come up with
02/07/2010.
I have joined 3 files from an accounting SQL database to import sales data
into Access.
Thanks for any help and I know I will have more questions.
Lee

 

[Duane Hookom]

You didn't suggest whether the value you have is string or numeric. Access
VBA uses DateSerial() rather than Date(). The remainder should be easy for
you to figure out.

Duane Hookom
MS Access MVP

 

[Lee]

Thanks for the point in the right direction. It worked well with the
left,mid,right parts added.
Thanks again.
Lee