Table Name:Customer
Fileds: CID - Autonumber
: Name
: Status (Suspended / Active / Terminated)
: Date
Above are the fields of my customer table and i just wanted to know how to get lastest status of each customer.
Eg:Customer A might have many records such as suspended on 20th may and again active on 25th may like so on...
Pls help me on how to do this...
thanks in advance
ibrahim