Recent content by Strife

Thanks so much DCrake. It worked nearly perfectly, all I had to do was changed TmpArray to Dim TmpArray as Variant because I was getting the error 'Can't Assign an Array' and it looks like you have to define the variable as a Variant to fix it. But I tested it and it works perfect now...

I have a large oracle table that has data stored for each day of the week all in one column. For example, the ratebyday column that has the rate for each day of the week. Is there a process to easily split out the data into 7 columns in a query just using the delimiter? I would use left() or...