I can't save this query

[blue875]

SELECT Service.Name As AtlasProductName,
IIf(Service.Name Like "1004*", "1004/URAR",
IIf(Service.Name Like "2055E CompPhots&Land", "2055 Ext w/Comp Pics",
IIf(Service.Name Like "2055I CompPhots&Land", "2055 Int w/Comp Pics",
IIf(Service.Name Like "2075 Property Insp", "2075 Exterior",
IIf(Service.Name Like "Final Inspection", "442 Completion Cert",
IIf(Service.Name Like "704B No Comp Photos", "704 D/B no comp photos",
IIf(Service.Name Like "704B w/Comp Photos", "704 D/B w/comp photos",
IIf(Service.Name Like "*Desk Review", "Desk Review",
IIf(Service.Name Like "FHA 1004", "FHA - 1 Unit",
IIf(Service.Name Like "2000 Field Review", "FRR - Field Review",
Service.Name)))))))))) As CombinedProductName
FROM (VendorServiceOrder INNER JOIN (ProductOrder INNER JOIN ((Product
INNER JOIN ProductCategory ON Product.ProductCategoryID =
ProductCategory.ProductCategoryID) INNER JOIN ProductGroup ON
ProductCategory.ProductGroupID = ProductGroup.ProductGroupID) ON
ProductOrder.ProductID = Product.ProductID) ON
VendorServiceOrder.ProductOrderID = ProductOrder.ProductOrderID) INNER
JOIN Service ON VendorServiceOrder.ServiceID = Service.ServiceID
WHERE (((ProductGroup.Name) Like "ap*"));

When I try to save this query, Access shuts down and the query is not
saved. All tables and names are valid and joined correctly.

[AP]

I believe you have too many nested IIFs, I believe there is a limit of
7. You may want to create a user function using and use a select case
statement to join the values and return the appropriate string.