SQL select statement

I have an Access table with the following fields:
fldID(autonumber),fldLotNo, fldLength, fldDiameter, fldFrom, fldTo

This table has multiple records with the same fldLotNo value. The table is tracking the movements of the fldLotNo's from one warehouse to another. I'm trying to create a query that will select distinct fldLotNo records based on it's highest fldID value, thus giving me each fldLotNo's current warehouse location.

Help!

Thanks,

Jeff Sizemore

I believe you want something like this:



"SELECT DISTINCT field1, MAX(field3) AS max_ID FROM myTable GROUP BY field1"