How to get the Last Date inf Access Field

Hello Genius ...!!!
i have database file with updating regularly,
the database field is PurchaseDate which has for stored the product purchasing dates. now what i want, i want to get the buyer like 'timple' last purchasing date

so i use this below query but 'lastdate' i don't know which keyword is helping to getting LastDate

Code:

---

Select  lastdate From productsSale Where custname = 'timple'

---

==========================
Database : Ms Access [mdb file], OleDb
PurchaseField : Date/Time
==========================

Thanks ....

Thread moved to the 'Database Development' forum - which is where you should always post SQL questions (while SQL can be used in VB.Net, it is certainly not specific to VB.Net)


To get the highest value of a field (unless it is text/char based), use the Max function, eg:

Code:

---

Select Max(PurchaseDate) as lastdate From productsSale Where custname = 'timple'

---

ooh thanks Genius sorry for wrong place post .... k i'll try it and reply soon ...thanks