Hi Sky,

FWIW the access solution in an Access newsgroup group was
sorry for the beta.google format -- I hope this is short-lived on
Google's part.
http://groups-beta.google.com/group/...b0bcc0a46fa831

I usually go with trying to fix data at the source (GIGO, garbage in garbage out)
if I have control of both.

"Sky Warren" wrote...
Please disregard this post. A solution was provided in the Access forum by 3
guys that absolutely ROCK!!!