Recent content by rdshag

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

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 pick XE from the drawing list box and I make no changes to it

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

thanks to you all that works

thanks I will try that

I am trying to do what I did in excel =LOOKUP(AF160417,Location!A:A,Location!B:B)

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