Dear Sir or Madam,



I have a table which holds a status( Stop, Start, GO,Hold), which can 

change by week. 

Status Table = Status/EntryDate(optional)/StatusID(not Shown)

(Dates are only entry dates-can not use to sort)

EG. Parcel 235, Monday on Hold - 8/19/2001

    Parcel 235, Tuesday  -Start  - 9/14/2001

    Parcel 235, Wedneday -Stop   -9/15/2001

    Parcel 235, Friday - Go     - 9/01/2001

This is displaying in a subform, but I have to show another subform with a 

query which shows the StatusID(max) which is the most recent status



This is all in Access 97