Rest well and thank you very much!
Basically I'm trying to manipulate data that's being
brought in by a query. That data has to be split into two
separate fields but placeholders have to be kept. For
instance, if "01030407" comes in, then the field has to
look like this: "01 0304 07". I can write an array in
Visual Basic to handle the place holding, etc...but I was
hoping it could be linked to the query.
Thanks again,
Jack