G
Guest
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
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