listing records from 2 database tables even if there are no values inone table

  • Thread starter Thread starter shama8
  • Start date Start date
S

shama8

I hope that this makes sense, but as an example:

I have 2 databases. The first one (db1) contains Product Name &
Serial Number. The second (db2) contains Serial Number and Price (but
does not contain all of the records in db1). I want to see ALL
Product Names (from db1) and Prices (from db2), where price is
available. When I link "Serial Number" from each database, I only get
the common results, withe some Product Names eliminated.

How could I get All Product Names and Prices, showing "n/a" (or
something like that) when there is no Price on record?

Any help is greatly appreciated. Thanks!
 
shama

you need to click on the link between the two table in the select query (
design view) and change the joint so that it "contains all the data from db1
table"

regards

raf
 
There may be a confusion of terminology here.

Each MS Access .mdb file is considered a "database (db)". Within each .mdb
file there may be multiple "tables". Each table holds fields (or columns).

Are your [Product Name] and [Serial Number] the names of fields or the names
of tables or the names of databases?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top