jamesaarnold
Technical User
I am using access 97..I have a table with a field that has 2 pieces of information in a single field..
1. supplier name
2. engineer name
example.> basf-fred smith
I'm trying to query on the second part of the data only
example.. tell me all suppliers for fred smith
I know it would probably be easier to split the data into two seperate fields.., But the data is imported from another database that I do not control.So unfortunatly, I cannot do this without spending an enormus amount of time splitting the data into 2 seperate fields.
Any Help would be greatly appreciated!
James
1. supplier name
2. engineer name
example.> basf-fred smith
I'm trying to query on the second part of the data only
example.. tell me all suppliers for fred smith
I know it would probably be easier to split the data into two seperate fields.., But the data is imported from another database that I do not control.So unfortunatly, I cannot do this without spending an enormus amount of time splitting the data into 2 seperate fields.
Any Help would be greatly appreciated!
James