-
Separate digits in record Access Query
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|