select latest records

[John_Bavin]

How do I select the current or latest record in a table. For instance a
price list where we have new prices for the same product code with an
effective date. How do we select the last record before the current date for
each iem in the list?

 

[vanderghast]

There are four methods at http://www.mvps.org/access/queries/qry0020.htm.
The first one is probably the easiest one, but it is done in two queries:
One which find the maximum date_time for each product code, and one which
makes an inner join with the original table and the two fields of the
previous query you just made.


Vanderghast, Access MVP