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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shama8@gmail.com - 06 Feb 2008 16:50 GMT

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!

Reply to this Message

RAf - 06 Feb 2008 17:07 GMT

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

> I hope that this makes sense, but as an example:
>
[quoted text clipped - 9 lines]
>
> Any help is greatly appreciated. Thanks!

Reply to this Message

Jeff Boyce - 06 Feb 2008 18:20 GMT

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

>I hope that this makes sense, but as an example:
>
[quoted text clipped - 9 lines]
>
> Any help is greatly appreciated. Thanks!

Reply to this Message