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

Alhamdulillah...

Thanks berat mas N17R4 H4F45...saya berhari gak ketemu caranya...

Thanks [belajar-access]

-----Original Message-----
From: N17R4 H4F45 <nitra_hafas@yahoo.com>
Sent: Tuesday, November 23, 2010 22:15
To: belajar-access@yahoogroups.com
Subject: 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
++++++++++++++++++++++++++++++++++++++++

[The entire original message is not included]

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/