Arsip: mencari tau jumlah hadir pada absen bulan yang telah lewat

more 9 years ago
awing
teman2 tolong minta pencerahan y saya punya tabel absen dan tabel bayar gaji sedangkan tabel bayar gaji berdasarkan jumlah absen keadiran pada bulan yang telah lalu, turs yang jadi masalah gmana melihat or menjumlahkan data dan menampilkan absen pada bulan yang telah lalu pada form bayar gaji saya dah pernah coba tapi masih lom ketemu saya minta teman2 dapat membantu makasi
WITH DM.QTABSENMASUK do
begin
DM.QTABSENMASUK.SQL.Clear;
DM.QTABSENMASUK.SQL.Text:='SELECT count(NIPO)as jumlah FROM TABSENMASUK where NIPO = ' + QuotedStr(FBAYAR.NIPO.Text);
DM.QTABSENMASUK.Close;
DM.QTABSENMASUK.Open;

more 9 years ago
mas_kofa
dari query di atas tinggal kamu tambahi (asumsi db_engine : mysql)
and MONTH(TGL_ABSEN) = MONTH(NOW()) - 1
//filter di atas masih berlaku jika transaksi belum melampui satu tahun, jika udah melampui satu tahun hasil nya akan kecampur dengan data tahun sebelumnya pada bulan yang sama.....
more 9 years ago
unggulresearch
to mas kofa, q mw hub km, ada keperluan bisnis mas,, ada kontak yg bs sy hub mas ??
please urgent..

more 9 years ago
MrLee
@unggulresearch: to mas kofa, q mw hub km, ada keperluan bisnis mas,, ada kontak yg bs sy hub mas ?? please urgent..cek link signiture nya, pasti ada d sana tuh mas kofa
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- tanya skin bro
by putra in Enginering more 15 years ago - Gimana caranya menghadle close ditaskbar
by mankerman in Network, Files, I/O & System more 11 years ago - Embed sound
by wiedhodho in Hal umum tentang Pascal Indonesia more 14 years ago - [Ask]User login ID and password
by vahnkrist in Bedah Kasus more 8 years ago - Membuat report di delphi ?
by jajang in Reporting more 12 years ago - Handle error "login database di MySQL"
by zuq in Tip n Trik Pemrograman more 12 years ago - Isi Edit Box tidak berubah
by onsir in Hal umum tentang Pascal Indonesia more 13 years ago - Bikin Thread Dulu Ah...
by tendafahmi in OOT more 10 years ago - [?] Membuat Judul Dinamis di Fast Report?
by babypigs in Reporting more 13 years ago - Looping
by teru2bozo in Tip n Trik Pemrograman more 13 years ago