access97: date string

Can anyone give me some direction on how to return values without the "/"
since access imports the "7/1/2003" with the "/".

in my query i tried: 

date: (DatePart("mmddyyy",[Field2]))

but i received an error message in the field "#Error" when i go to view it.

eventually i want to export it to a text file but when i do export it,
it still formatted as "7/1/2003" instead of "07012003".

any help would be appreciated.
thanks- jung