Why won't this work???

G

Gina Whipp

Expr1:
DLookUp("Client","qryClientNames","cpCustomerID=Left([ncAUPReferenceID],2)")

Thanks in advance.... Gina
 
R

Rick Brandt

Gina said:
Expr1:
DLookUp("Client","qryClientNames","cpCustomerID=Left([ncAUPReferenceID],2)")

Thanks in advance.... Gina
Click to expand...

Where are you putting this and what exacty is [ncAUPReferenceID]?
 
G

Gina Whipp

Thanks for you speedy reply but I changed it from the query directly to the
report and it works like a charm!


Rick Brandt said:
Gina said:
Expr1:
DLookUp("Client","qryClientNames","cpCustomerID=Left([ncAUPReferenceID],2)")

Thanks in advance.... Gina
Click to expand...

Where are you putting this and what exacty is [ncAUPReferenceID]?
Click to expand...
 
Top