Senior moment on capturing all records from joined query

  • Thread starter Thread starter Thor
  • Start date Start date
T

Thor

I'm having a terrifying "senior moment." I'm linking two tables, and I want
all the records from the first table and any records from the second table
that match unique identifier. I just can't remember how to configure the
query for that.
In other words, let's say 1st table has 10 records. 2nd table has data
fields I want to add to the first to create a new table that still has 10
records, but more columns of data. I should be able to create a query that
let's me capture all 10 records from table no. 1, and any matches from table
no. 2
 
In Query design view, double-click on the join line between the two
tables. Select the option that gives you all records from the first
table and only matching from the second table.

As long as you don't use criteria involving the second table, this
should work for.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top