i have a table and a query.
the table consist of the list of all clients(A) and the query consist of the list of clients that has made the payment (B)

i want to make query from the table list of clients that has not make any payment only. A not B or A<> B.
(check my attachment)

i was trying to use:

SELECT ([Tabel client list].[client name])
FROM [Tabel client list], Query_Paid
WHERE ((([Tabel client list].[client name])<>Query_Paid![client name]));


it never works.

it will show the all client name from the table client list followed by client names that
has not make any payment. it will looks like a duplication data.

any idea ? help needed

thanx before ...

Have you tried the unmatched query wizard?

not yet, how to do that ? i've never found that

When you select new query it comes as 1 of the 5 options in the menu

Brian

From where did the query get the list of clents that have paid?

Brian

it was from other table(payment table).

thankyou that was solve my problem.

thanx....