Matching Records in two Tables

[nmk]

I have a master list of countries in one table and list of countries with
prices in the other table.

I am trying to build a query that finds a match for every country in the
master list from the other pricelist and pulls a price accordingly.

What is the best way to do it? Thank you for your help.

 

[John Spencer]

-- Add both tables to the query
-- Drag from the country field in the master list to the country field
in the pricelist
-- double-click on the join line and in the dialog box, select show all
in master list and show matches in pricelist
-- choose the fields you want to show

This will show all the countries in the master list with matching
information in the price list and any master list countries that don't
have a match will show blanks for the fiels in the pricelist

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================