Why won't this work???

  • Thread starter Thread starter Gina Whipp
  • Start date Start date
G

Gina Whipp

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

Thanks in advance.... Gina
 
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]?
 
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...
 
Back
Top