/* */

Friday, November 25, 2011

Re: [belajar-access] Pembulatan ke 100 Rupiah

 

Silakan di pilih sesuai keinginan:
 
SELECT tblData.Angka, 100*Round([angka]/100,0) AS Mendekati, 100*Int([Angka]/100) AS [Round Down], -100*Int([Angka]/-100) AS [Round Up]
FROM tblData;


Thank you | Terima Kasih | Matur Suksema

Sumiyanto

--- On Thu, 24/11/11, sam duhay <samduhay@yahoo.com> wrote:

From: sam duhay <samduhay@yahoo.com>
Subject: [belajar-access] Pembulatan ke 100 Rupiah
To: belajar-access@yahoogroups.com
Received: Thursday, 24 November, 2011, 1:08 PM

 

Asalamulaikum, 

Para Teman Teman Acesser  semua,   Saya minta bantuanya
tentang pembulatan angka ke seratus jika ada pecahan dibawah seratus Rupiah

 tabel nya sbb

Rp                    dibulatkan

1566                    1600
1709                    1800
667                      700
2025                  20200
1000                  1000      ( tetap)
0                        0

saya sdh coba buat tp kok Kacau

fungsi dalam bentuk SQL ( Query )

Demikian Terima kasih yang Banyak 

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___
Posted by NINO at Friday, November 25, 2011

2 comments:

  1. Mr_YantoApril 27, 2016 at 10:27 AM

    MASALAH KITA SAMA DAH NEMU BELUM SOB? KALAU BELUM COBA IKUTIN PETUNJUK DARI : https://cakyanto.wordpress.com/2011/11/29/query-dan-modul-round-up-100-dalam-access/
    SAYA DAH MENCOBA NGIKUTI PETUNJUK BELIAU ALHAMDULILLAH MASALAH SAYA DAH TERPECAHKAN...

    ReplyDelete
  2. AnonymousJuly 23, 2017 at 5:11 PM

    Public Function Bulat(ByVal nNilai As Double, nDigits As Integer) As Double
    Bulat = Int(nNilai * (10 ^ nDigits) + 0.5) / (10 ^ nDigits)
    End Function

    ReplyDelete

Subscribe to: Post Comments (Atom)