DMax

[Guest]

I have a table with mileages for 10 vehicles. The values range from 0 upto
70,000. For each mileage record (aproximately every 3,000 miles) there is a
date at which the vehicle reached this milestone. In a report i want to
extract the most recent mileage record for each of the ten vehicles.

I have tried to use the Dmax function but i dont seem to have written the
formula correctly. Because the one column has the data for all ten vehicles,
I am finding it difficult to pull out the most recent mileage for EACH
vehicle, and not just the most recent mileage overall.

Any suggestions?

Crimbo

 

[Guest]

Create a new query
Select the table you are using
Select the two fields, car and mileage (double click on them)
From the ToolBar click on the button that has this symbol ∑ , (group by query)
Now, in the query there will be another row GROUP BY , in the mileage select
Max, now running the query should display a car with max mileage