Iya, itu sudah saya coba bisa yaitu pengurangan tanggal hasilnya bulat bila format dan decimal placesnya diganti.
"Adhi Jakarta" <[email protected]> Sent by: [email protected] 04/14/2009 09:19 AM Please respond to belajar-access To: [email protected] cc: Subject: [belajar-access] Re: Pembulatan hasil Maksudnya mau dihitung berapa jumlah bulan bulan dari tgl jatuh tempo sampai tgl sekarang? kalo di query bawa kursornya ke field yang anda ingin bulatkan klik kanan pilih properties Format nya dipilih fixed decimal places diisi nolai 0 (nol) Mudah2 jawabannya seperti yang dimaksud dalam pertanyaan. --- In [email protected], planner_grnt <planner_g...@...> wrote: > > Yth, milister belajar acces, > > cara pembulatan hasil pengurangan dg type tanggal baagimana ya..? > misal : ([Tgl sekarang] )-([tgl jatuh tempo]), sy ingin hasilnya angka > pembulatan misalnya = 30 > saya coba di query banya anka desimalnya, mohon pencerahan dari > rekan-rekan , > terimakasih sebelumnya. > > Salam > herman > =========================================================================== This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. The Trakindo Group of Companies do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by the Tiara Marga Trakindo Group of Companies and this email is not an offer, solicitation, recommendation or agreement of any kind. ===========================================================================
