Query Opposite

Rivers

New member
Local time
Today, 15:28
Joined
May 3, 2004
Messages
5
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
 
Mile-O-Phile said:
Change the = to <>
Sorry but that doesn't work. What I am getting is a list of all the locations for all the other customers.

Edit: I solved it :)
 
Last edited:

Users who are viewing this thread

Back
Top Bottom