design querry help

[Debbie]

Hello,
I have a database with various tables. It is used to
track to progress of a product through the different
stages. The problem I am encountering is that in 3 of
these stages(tables), the product could cycle through
several times. The current setup creates a new record for
each delivery.

That is okay, but when I run a querry, the product is
listed multiple times, and I only need the most current
record. How can I do this?
Thanks,

 

[[MVP] S. Clark]

Do it with two queries. The first pulls the Max of Date based on the
Product ID and Step.

The second query links to the first by the Date, ProductID, and Step.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Debbie]

I am really new at this. Would you do this in sql, or in
design query? How? Help Please
Thanks in advance