@rfigueroa1976,
You've got to forget anything you know about Excel; Access and Excel are tow completely different animals!! Access tables DO NOT have "Cells"; even though an Access table LOOKS like a worksheet, they are NOT the same.
Excel has Rows and Columns,
Access has Records and Fields. An Access table does not have "Cells".
The image (Rootcause Hierarchy SQL.jpg) in Post #1 must be a query?
In the image, you are looking at the field "Root Cause", but your formulas use "Description"???
You might try using the SWITCH() function:
Code:
<snip>
dbo_NCR_IncidentTypes.Description AS [Incident Type],
dbo_NCR_RootCauses.Description AS [Root Cause],
Switch (dbo_NCR_RootCauses.Description LIKE "Carrier*", "1-Carrier", dbo_NCR_RootCauses.Description LIKE "Shipper*", "2-Shipper", dbo_NCR_RootCauses.Description LIKE "Consignee*", "3-Consignee", "Other") AS FaultHierarchy,
dbo_NCR_PreventiveActions.Description AS [Preventive Action],
<snip>