query need help

[gendrix]

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 ...

 

[pbaldy]

Have you tried the unmatched query wizard?

 

[gendrix]

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

 

[Brianwarnock]

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

Brian

 

[Brianwarnock]

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

Brian

 

[gendrix]

it was from other table(payment table).

thankyou that was solve my problem.

thanx....