Hi,
I just need to know how to parse to string/text format?

jlabre01

In MS Access help look up the right() left() and mid() functions.

In MS Access help look up the right() left() and mid() functions.

If you are going to parse, then two more good functions to know would be InStr(Start, String1, String2) and Len(String)

Forgot those - :)

If you are going to parse, then two more good functions to know would be InStr(Start, String1, String2) and Len(String)

I'll throw out one more good one to know:

InstrRev(StringToCheck As String, StringToMatch As String, Optional Start As Long, Optional Compare As VbCompareMethod)

Thanks to all, I got it to work

jlabre01