Dear mbak Asma Yanti,
Terima kasih atas bantuannya...
Tapi sayang sekali, enggak cocok kalo diterapkan di access...
Jadi masih belum jalan juga nih...
Mohon petunjuk lagi dari mbak maupun rekan yang lainnya...
Makasih en wassalam,
Darmawan
ay> Mau coba bantu..
ay>
ay> kalau saya pernah buat tapi di sql server , sintaknya begini
ay>
ay> CREATE PROCEDURE [Nama store procedure] AS
ay> SELECT (MAX(nama field) + 1) AS Nama alias FROM Nama table
ay>
ay> jadi contohnya begini
ay>
ay> CREATE PROCEDURE [OrderKey] AS
ay> SELECT (MAX(ORDERKEY) + 1) AS NomorUrut FROM ORDERDETAIL
ay>
ay> kalau di access saya belum pernah coba.. tapi mungkin sama..
ay>
ay> Mungkin ada saran dari rekan2 yang lain..
ay> milist MSD <[EMAIL PROTECTED]> wrote:
ay> Dear all,
ay> Masalah lain muncul nih...
ay> Perasaan dulu ada yang pernah nanyain masalah ini, tapi koq belum ada
ay> jawabannya ya???
ay> Bagaimana cara membuat nomor urut dengan menggunakan SQL pada access
ay> ???
ay> Mohon petunjuknya... please...
ay> Makasih sebelumnya...
ay> wassalam,
ay> Darmawan
ay> Yahoo! FareChase - Search multiple travel sites in one click.
ay> Untuk keluar dari millis ini, kirim email kosong ke:
ay> [EMAIL PROTECTED]
ay> SPONSORED LINKS
ay> Programmer Indonesia Basic programming
ay> language Computer programming languages Programming
ay> languages Java programming language
ay> YAHOO! GROUPS LINKS
ay> Visit your group "Programmer-VB" on the web.
ay> To unsubscribe from this group, send an email to:
ay> [EMAIL PROTECTED]
ay> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
