L
Les
Patrick,
Do you know if the model with the most recent date is
always the one with the highest price? In other words, is
the data that you want always contained in the same row?
If so, you can create a new query, click on the totals
button, leave Model # set to group by, and change Date and
Price to Max.
the eliminations are based on other fields. For example: I
have the following fields:
records with that model number.
Do you know if the model with the most recent date is
always the one with the highest price? In other words, is
the data that you want always contained in the same row?
If so, you can create a new query, click on the totals
button, leave Model # set to group by, and change Date and
Price to Max.
field. I want to eliminate all but one of those fields but
the eliminations are based on other fields. For example: I
have the following fields:
and the most recent date. How do I eliminate the other
records with that model number.