Senior moment on capturing all records from joined query

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
 
J

John Spencer

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
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Have both records from two queries/tables under one Query without related fields. 0
Query Not Displaying All Main Table Records 1
Query and relationships 4
Need a query to get rid of duplicates using two tables 1
Query not bringing up all records 3
Query return duplicate results 1
Why does MSAccess cut query after 2886000 records 1
Query to show all records of one table and updated info from anoth 3

Top