Expression entered is invalid.

[pr2-eugin]

Hi. I have a table(BR) with some ID's. I am trying to write a query to select all the details of customers who has a cancelled status, and also who are not in the BR table. So i tried the following code but it is not working. instead throwing an error "operand without an Operator". Any idea why.

I am writing the condition code below.

WHERE Cust.[Cust_ID] <>"&DLookUp("ID","BR") &"

 

[pr2-eugin]

well i found out one problem. the error was because the field in the table BR was text so i had to use single quotes around it.. anyway my problem still is not resolved.. as the table BR contains more than 100 entries. I need to display the details of customers whose Cust_ID is not present in the BR if present it should not be displayed in the result. is my query condition correct.

WHERE Cust.[Cust_ID] <> ' "&DLookUp("ID","BR")&" '

 

[bob fitz]

Have you tried creating this query with the "Find Unmatched Query Wizard" ?