Query Problem

#1

Hi All,

I have two tables (book and reference) that share a common field, ISBN.

Both tables are supposed to have matching entries.

I need a query that displays records that exist in the book table, but are missing from the reference table.

Thanks very much,
Chuck

#2

Chuck
When you are in queries, click new on the menu bar.
One of the choices is the unmatched query wizard.
That should do it.

Good luck
Ira Solomon

On Tue, 12 Jul 2005 01:52:16 GMT, "Chuck Insight"
<j.gillham (AT) insightbb (DOT) com> wrote:

Quote:

Hi All,

I have two tables (book and reference) that share a common field, ISBN.

Both tables are supposed to have matching entries.

I need a query that displays records that exist in the book table, but are missing from the reference table.

Thanks very much,
Chuck

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query Problem

comp.database.ms-access comp.database.ms-access

Query Problem - 07-11-2005 , 08:52 PM

Re: Query Problem - 07-11-2005 , 09:27 PM