This is my SQL statement. Kind of messy but it works... Any help you could give with changing it would be great. I am bolding the 2 fileds that contain text strings that I would like to break up into columns.

SELECT "Inventory Master File".ITEM_NUMBER, "Inventory Master File".DESCRIPTION_1, "Inventory Master File".COMMITTED, "Inventory Master File".WAREHOUSE_MTD_USAGE, "Inventory Master File".WAREHOUSE_YTD_USAGE, "Inventory Master File".LAST_YEAR_USAGE, "Inventory Master File".USAGE1_12, "Inventory Master File".USAGE13_24, "Inventory Master File".MAJOR_PRODUCT_CODE, "Inventory Master File".MINOR_PRODUCT_CODE
FROM "Inventory Master File" "Inventory Master File"
WHERE ("Inventory Master File".ITEM_NUMBER Not Like '*%' And "Inventory Master File".ITEM_NUMBER Not Like 'CRE%' And "Inventory Master File".ITEM_NUMBER Not Like 'SPC%' And "Inventory Master File".ITEM_NUMBER Not Like 'T%') AND ("Inventory Master File".MAJOR_PRODUCT_CODE Like 'DOR%')