I need oppersite
I am trying to get the opposite if this query
SELECT tbl_location.fld_location_no
FROM tbl_location INNER JOIN tbl_board ON tbl_location.fld_location_no = tbl_board.fld_board_location_no
WHERE (((tbl_board.fld_board_cust_no)=[Forms]![frm_new_customer]![location].[Form]![fld_board_cust_no]));
I want to see what locations the customer is not at
I am trying to get the opposite if this query
SELECT tbl_location.fld_location_no
FROM tbl_location INNER JOIN tbl_board ON tbl_location.fld_location_no = tbl_board.fld_board_location_no
WHERE (((tbl_board.fld_board_cust_no)=[Forms]![frm_new_customer]![location].[Form]![fld_board_cust_no]));
I want to see what locations the customer is not at