Query Questioin

[Nothing]

I have two tables that has the following:

Table #1
AuctionDate
BidderNumber
FirstName
LastName
TaxExempt

Table #2
AuctionDate
BidderNumber
PaymentMethod
PaymentNumber
Amount

I want to have a query tell me which bidders are in table #1 are NOT in
Table#2. Anyone have any ideas as to how to do this? I cant seem to
figure it out.

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Larry Linson]

Re: Query Questioin

On the database window, click the Queries tab, then click the New Button,
and in the dialog that pops up, select "Find Unmatched Query Wizard".

That should do what you want. And, not only that, you can look at what it
generated just in case you want to do it without the Wizard next time, or
want to modify it.

Larry Linson
Microsoft Access MVP


"Nothing" <me@you.com> wrote in message
news:3f9b344a$0 $202$75868355@n ews.frii.net...[color=blue]
> I have two tables that has the following:
>
> Table #1
> AuctionDate
> BidderNumber
> FirstName
> LastName
> TaxExempt
>
> Table #2
> AuctionDate
> BidderNumber
> PaymentMethod
> PaymentNumber
> Amount
>
> I want to have a query tell me which bidders are in table #1 are NOT in
> Table#2. Anyone have any ideas as to how to do this? I cant seem to
> figure it out.
>
> Michael Charney
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]

[Pieter Linden]

Re: Query Questioin

Nothing <me@you.com> wrote in message news:<3f9b344a$ 0$202$75868355@ news.frii.net>. ..[color=blue]
> I have two tables that has the following:
>[/color]
Records in table1 that are not in table2.

SELECT *
FROM Table1 LEFT JOIN Table2 ON Table1.BidderNu mber=Table2.Bid derNumber
WHERE Table2.BidderNu mber IS NULL;