|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 22nd, 2009, 10:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Creating Multiple Records from Single Delimited Field
I am working with some data that lists Supervisor Hierarchy in a Pipe
Delimited format and I want to be able to have it show in a query based on each level of the supervisor. Example: Name SupervisorHierarchy John Smith |White|Lee|Martinez|Scott| Jim Jones |Clark|Wright|Jackson|Johnson|Hill|Lewis| Ideally I would like to see Name Supervisor Level John Smith White 1 John Smith Lee 2 John Smith Martinez 3 John Smith Scott 4 Jim Jones Clark 1 Jim Jones Wright 2 Jim Jones Jackson 3 Jim Jones Johnson 4 Jim Jones Hill 5 Jim Jones Lewis 6 
|
|
#2
December 23rd, 2009, 03:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Creating Multiple Records from Single Delimited Field
Is there a maximum number of values in the SupervisorHierarchy field? Do you
have a table of every unique last name? What happens if two people have the same last name? -- Duane Hookom Microsoft Access MVP "MSJ" wrote: I am working with some data that lists Supervisor Hierarchy in a Pipe Delimited format and I want to be able to have it show in a query based on each level of the supervisor. Example: Name SupervisorHierarchy John Smith |White|Lee|Martinez|Scott| Jim Jones |Clark|Wright|Jackson|Johnson|Hill|Lewis| Ideally I would like to see Name Supervisor Level John Smith White 1 John Smith Lee 2 John Smith Martinez 3 John Smith Scott 4 Jim Jones Clark 1 Jim Jones Wright 2 Jim Jones Jackson 3 Jim Jones Johnson 4 Jim Jones Hill 5 Jim Jones Lewis 6 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
