Re: Linking data
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Thu, 17 May 2007 12:57:28 -0400
I believe that a query like the following should work.
SELECT AllRecords
FROM (AllRecords LEFT JOIN Cars
ON AllRecords.[Account Number] = Cars.[Account Number])
LEFT JOIN Trucks ON
AllRecords.[Account Number] = Trucks.[Account Number])
WHERE Cars.[Account Number] is Null and Trucks.[Account Number] Is Null
You were given instructions on how to build this query in the grid. Did you
try it? Did it fail? If it failed, how did it fail? Did you get the wrong
records, no records, an error message? You have to tell us, we cannot see
what happens, you can.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
"joey" <joey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74050893-539D-46B7-BA47-2042FA080286@xxxxxxxxxxxxxxxx
Hello,
I have three tables with the same unique identifier - Account Number
One table has all the records
One table has Cars
One table has Trucks
What I would like to do is run a query that displays the Account Numbers
that have neither Cars nor Trucks.
Thanks in Advance.
.
- Prev by Date: Re: percentage calculation...trying again
- Next by Date: Re: Stumped with an upcoming birthdays query
- Previous by thread: union all on 2 select statements -- see error message - please help
- Next by thread: Re: Deletion of rows based on Conditions
- Index(es):
Relevant Pages
|
