Search results

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...

I have created two queries query one "drawing list" has the drawing number and equations that beak the number into segments example yyy-drw-xe-001 yyy drw xe 01 query two I have a table and drawing list query with the drawing numbers linked when I bring an equation in from...

I have two Query, 1. Open item query - this is were I what to run dlookup, and the Expr2 is the field that I want looked up. 2. location query - has what I an looking for if expr2 = [location query]![location] then give me what is in column [location query]![l-pre] this is the equation that I...