query not working

[Guest]

SELECT DISTINCT Left([COSTS].[Account],4) AS TEST, costs.Amount
FROM [L-LINE-ITEMS], costs
WHERE (((Left([COSTS].[Account],4)) Not In (SELECT [L-LINE-ITEMS].

FROM [L-LINE-ITEMS])));

Does not return any records even thougth there are records in table "costs"
that are not in "L-LINE-ITEMS"?  What am I doing?  Or not?

Thanks

 

[Guest]

hi,
if you are trying to write a "not in" query, you are way
off the mark.
in the database window-query tab click the new button.
there is a 'find unmatch query wizard'. build the query in
design mode then look at the sql.
you will have to join both tables and switch "not in"
to "is null".
good luck.