select all records on one table but limit records from 2nd table

select all records on one table but limit records from 2nd table

Post by am9hb » Thu, 04 Nov 2004 03:07:01


here are the table i am working with

tbl_mstr:
accession number (primary)
name
accession date

tbl_journal1:
record number (primary)
accession number
date
task (list box)
deaccession (list box)


these tables have a one(tbl_mstr) to many relationship(tbl_journal1)

i would like to create a query that would return all the records in tbl_mstr
but from tbl_journal1 only those records where the deaccession field is
populated with data.

my attempts result in a query that returns dublicate results from tbl_mstr
because of the many entries that one accession might have in tbl_journal1 OR
if i try to limit the results from tbl_journal1 i get only those records that
meet what ever criteria i enter.

as you might suspect, i have very limited know how with access.

TIA
 
 
 

select all records on one table but limit records from 2nd table

Post by Q2hyaXN » Thu, 04 Nov 2004 04:28:01

In your query, include the where clause

Where deaccession is not null