M
Michelle
Can I convert text to columns in a query? I know I can do it in Excel, but
I'd rather not have to maintain a linked Excel table in my query. Here's the
field that I'm trying to seperate:
Field 1:
2.00% @ 24 3.00% @ 24 4.00% @ 48
I want it to show up in my query as six different fields, like this:
Field 1: Field 2: Field 3: Field 4: Field 5: Field 6:
2.00% 24 3.00% 24 4.00% 48
Is this possible?
I'd rather not have to maintain a linked Excel table in my query. Here's the
field that I'm trying to seperate:
Field 1:
2.00% @ 24 3.00% @ 24 4.00% @ 48
I want it to show up in my query as six different fields, like this:
Field 1: Field 2: Field 3: Field 4: Field 5: Field 6:
2.00% 24 3.00% 24 4.00% 48
Is this possible?