Seperate multiple data in 1 feild

[Gary Eck]

I have a table that has price breaks seperated by semi-colons in 1 field. (ex.) 100;200;1000 I need to seperate them in a query to create a price list. Can anyone HELP?

gary

 

[Gary Eck]

Seperate data

I can't change the table, because it is a linked Progress table. I thought there might be a function I could use in a query to take the one field and make it ex. (50;100;200;300;500) and make 5 feilds like (brk1)50,(brk2)100 and so on. Is there any advanced formula for the "Left" function?


Thanks,

Gary

 

[ck01]

Can someone please upload a sample database that demonstrates how to handle price breaks in a table. This could be what I am looking to do with a tiered commission structure that my company uses. Thanks!