Hello,

I am trying to create a query in access that will seperate each digit of a 96-digit cell into another column.

IE.
(Value of 96 digit cell)
01232100000000011332233333333333333300000000000000 0010000000000000000000000000000000000000000000
each digit represents a value for each 15 minute increment of the day, so the new columns would be:

COLUMN 1 COLUMN 2
0000 (12:00am) 0
0015 (12:15am) 1
0030 (12:30am) 2
0045 (12:45am) 3
0100 (1:00am) 2
and so on.

there's no spaces in the 96 digit value--idk why it puts a space there.

My goal is to create a chart based on the values in column 1 and column 2, but based off of original input data. ANY IDEAS would be appreciated.