[belajar-access] Re:

Ada cara lain yaitu First(...)
yaitu menemkan nilai yang pertama , misal id_siswa , maka :

query menemukan pertama :
select First(id_siswa) , ....

query sebelumnya :
select tb_siswa.id_siswa, tb_siswa.nama_siswa,
(select id_pembayaran from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran,
(select periode_bln from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran,
(select periode_th from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran
from tb_siswa

silakan di coba , kalau berhasil diberitahu, karena untuk buat tabel lagi malas nih.. , upload dong mdb-nya
'===========

--- In belajar-access@yahoogroups.com, FAJAR N <safety_zone1@...> wrote:
>
> Benar, seperti ini.
> Ternyata bisa dg fungsi Mins, tak terpikirkan sama sekali.
> Terima kasih banyak Pak Edi.
>
> Masalah sy putuskan Solved.
>
> Salam
> Fajar
>

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

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/