Data in one record supercedes old record

[clarkfedor]

I have a database that has a table that includes a "Spec#" field and a
"superseded spec#" field. The superseded spec# field says is the spec
that replaces the old spec. Most of the entries in this field are
blank as most specs are new. When I view/print a report, I want the
records whose spec#'s are anywhere in the "Superseded" field to not
show up.

Basically, I need a Record to be not seen when the primary key (spec#)
matches ANY number in an entire field that isnt the primary key field.
I hope I explained this so it makes sense.

 

[Jeff Boyce]

Not sure why this is posted in the tablesdbdesign newsgroup ... seems more
like a "query" question.

You can create a query that joins one instance of your table to another
instance of your table, from the Spec# field to the SupercededSpec#. If you
want to find Spec#s NOT IN SupercededSpec#, you could even use the Query
Wizard for the "unmatched" query.

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

 

[clark]

Woopsie, didnt realize this was tablesdbdesign. Sorry bout that, but
thanks a lot for the help! The unmatched query idea works great!