coba pakai ini
dim rs as recordset
set rs=currentdb.openrecordset("SELECT * FROM dd ORDER BY ID",dbopendynaset)
do while not rs.eof
rs.edit
rs!Hasil=rs("Record 1")-Val(Dlookup("Record 1","dd","ID=" & rs!ID-1& "")
rs.update
loop
rs.close
set rs=nothing
info hasilnya yah
ABRISAM
+62 896-8518-7025
Pada 25 September 2017 13.05, fajar.duri@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> menulis:
dd ID Record 1 Hasil Keterangan 1 2 1 id 2 - id 1 2 3 1 id 3 - id 2 3 4 1 4 5 1 5 6 1 6 7 0
Yth. Master2..
Mohon ilmunya bagaimna caranya mengurangi berdaarkan record sesudahnya (berdasarkan tabel diatas).
Terima kasih..
Agung Santoso
Telp.
HP: 087871076226
Tlp. 021-91466149
PIN BB : 76BE8FF8
Website:
__._,_.___
Posted by: Agung Santoso <programpajak@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar