I can't save this query

[blue875@carolina.rr.com]

SELECT Service.Name As AtlasProductNam e,
IIf(Service.Nam e Like "1004*", "1004/URAR",
IIf(Service.Nam e Like "2055E CompPhots&Land" , "2055 Ext w/Comp Pics",
IIf(Service.Nam e Like "2055I CompPhots&Land" , "2055 Int w/Comp Pics",
IIf(Service.Nam e Like "2075 Property Insp", "2075 Exterior",
IIf(Service.Nam e Like "Final Inspection", "442 Completion Cert",
IIf(Service.Nam e Like "704B No Comp Photos", "704 D/B no comp photos",
IIf(Service.Nam e Like "704B w/Comp Photos", "704 D/B w/comp photos",
IIf(Service.Nam e Like "*Desk Review", "Desk Review",
IIf(Service.Nam e Like "FHA 1004", "FHA - 1 Unit",
IIf(Service.Nam e Like "2000 Field Review", "FRR - Field Review",
Service.Name))) ))))))) As CombinedProduct Name
FROM (VendorServiceO rder INNER JOIN (ProductOrder INNER JOIN ((Product
INNER JOIN ProductCategory ON Product.Product CategoryID =
ProductCategory .ProductCategor yID) INNER JOIN ProductGroup ON
ProductCategory .ProductGroupID = ProductGroup.Pr oductGroupID) ON
ProductOrder.Pr oductID = Product.Product ID) ON
VendorServiceOr der.ProductOrde rID = ProductOrder.Pr oductOrderID) INNER
JOIN Service ON VendorServiceOr der.ServiceID = Service.Service ID
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]

Re: I can't save this query

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.