invalid procedure call in query

[rdshag]

SELECT [RIMS EDCRS].pd1_object_name, IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Incorporate: ProjDoc","C",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Reference: ProjDoc","N",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN-HOLD: Ref: ProjDoc","H",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN-WEC: Reference: ProjDoc","N",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN-FABCON: Ref: ProjDoc","F",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Reference: Vendor","N",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Incorporate: Vendor","C",44))))))) AS Expr11, [RIMS EDCRS].relation_name, [RIMS EDCRS].pd1_revision, [RIMS EDCRS].pd_object_name, [RIMS EDCRS].pd_revision, [RIMS EDCRS].pd_date_initiated, [RIMS EDCRS].pd_responsible_engineer, [RIMS EDCRS].document_status, [RIMS EDCRS].pd_title, [Drawing List].Expr2
FROM [RIMS EDCRS] INNER JOIN [Drawing List] ON [RIMS EDCRS].pd1_object_name = [Drawing List].F1
GROUP BY [RIMS EDCRS].pd1_object_name, IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Incorporate: ProjDoc","C",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Reference: ProjDoc","N",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN-HOLD: Ref: ProjDoc","H",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN-WEC: Reference: ProjDoc","N",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN-FABCON: Ref: ProjDoc","F",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Reference: Vendor","N",IIf([RIMS EDCRS]![relation_name]="PDoc-DCN: Incorporate: Vendor","C",44))))))), [RIMS EDCRS].relation_name, [RIMS EDCRS].pd1_revision, [RIMS EDCRS].pd_object_name, [RIMS EDCRS].pd_revision, [RIMS EDCRS].pd_date_initiated, [RIMS EDCRS].pd_responsible_engineer, [RIMS EDCRS].document_status, [RIMS EDCRS].pd_title, [Drawing List].Expr2
HAVING ((([RIMS EDCRS].relation_name) Not Like "*Proj Doc - Proj Doc*") AND (([RIMS EDCRS].document_status) Not Like "*Superseded*" And ([RIMS EDCRS].document_status) Not Like "*Void*"));


everything I add an equation from the drawing list I get and invalid procedure call

can anyone help

 

[Minty]

Your nested IIf might be the cause - I think the limit if 6 or 7 and you have 7. Try using Switch instead.


SWITCH() Function

SomeVariable = Switch(Test1, Value if Test1 is True, Test2, Value if Test2 is True, ... , TextX, Value if TestX is True)

 

[rdshag]

fixed the problem, I created the Query adding Drawing list first and they added the rems e&DCR, no errors this way