I have two tables - Products2 and FPSUM
I am creating a query to look up the Product Code from the FPSUM table and return a Product value (text field) from the Products2 table.
I have tried the following DLookUp and receive an error "Syntax error (missing operator) in query expression 'PI...