Re: [belajar-access] Mencari Jam terakhir dengan nilai terbesar

kalo gini cocok gak mas:

SELECT  top 1 Table1.Jam AS JaMaxD2

FROM Table1

WHERE (((Table1.Data2)=(SELECT Max(Table1.[Data2]) FROM Table1)))

order by Table1.Jam desc

 

WassWr  Wb

Nitra Hafas

Powered by Lenovo Uaaanyar  ®

+++++++++++++++++++++++++++++++++++++++
YM : nitra_hafas
Gtalk : nitrahafas
Email : nitra_hafas@yahoo.com
url : nitsangpujangga.blogspot.com
++++++++++++++++++++++++++++++++++++++++

---

From: "Mulyawan, Ayi Teguh" <mulyawan.tea@gmail.com>
To: belajar-access <belajar-access@yahoogroups.com>
Sent: Tuesday, November 23, 2010 20:50:13
Subject: [belajar-access] Mencari Jam terakhir dengan nilai terbesar [1 Attachment]

 

Dear accessers,

 

Saya dapet masalah lagi nih mohon bantuannya lagi…untuk gambaran saya attach file Database1.

 

Yang saya inginkan bagaimana caranya agar data pada JaMaxD2 pada Query Max Data2 hanya menampilkan 1 result saja dengan waktu/Jam yang paling terakhir?

 

 

 

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___