Re: Re: [belajar-access] Report Jatuh Tempo [1 Attachment]

<*>[Attachment(s) from Sofyan Efendi included below]

Halo Mbak Rimi, sebenarnya kita cukup buat satu query dengan data sumber
dari table Anggota saja. Cobalah buka attachment file yg saya kirim ini,
disana ada query "Query_by_Opi". Untuk tgl jatuh tempo lainnya silahkan copy
paste sambil modif sedikit dari kolom sebelahnya ya.

Rumus Inti : Tanggal Jatuh Tempo Identitas: DLookUp("[Tanggal Jatuh Tempo
Identitas]";"IDENTITAS";"[Nomor ID]=" & [Nomor ID] & " And [Tanggal Jatuh
Tempo Identitas] >=#" &
Format([Forms]![Fr_JatuhTempo]![txt_tglAwal];"mm/dd/yy") & "# And [Tanggal
Jatuh Tempo Identitas] <=#" &
Format([Forms]![Fr_JatuhTempo]![txt_tglAkhir];"mm/dd/yy") & "#")

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com/
----- Original Message -----
From: <rimi_doanksz@yahoo.com>
To: "Belajar-access" <belajar-access@yahoogroups.com>
Sent: Wednesday, May 23, 2012 8:10 AM
Subject: Bls: Re: [belajar-access] Report Jatuh Tempo [1 Attachment]


> Dear Pak Sofyan...
>
> Berikut saya kirimkan contoh file nya pak..
> Mohon pencerahannya...
>
> Trima kasih
>
> Rimi Amelindo
> Sent from my AXIS Worry Free BlackBerry® smartphone
>
> -----Original Message-----
> From: Sofyan Efendi <sofyanefendi@gmail.com>
> Sender: belajar-access@yahoogroups.com
> Date: Tue, 22 May 2012 16:35:22
> To: <belajar-access@yahoogroups.com>
> Reply-To: belajar-access@yahoogroups.com
> Subject: Re: [belajar-access] Report Jatuh Tempo
>
> Halo Mbak Rimi, untuk query spt ini, manfaatkan criteria "OR" yg tersedia
> di
> query. Namun agar lebih afdhol, Mbak Rimi kirim ya contoh filenya.
>
> Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
> Sofyan Efendi
> http://imopi.wordpress.com/
> ----- Original Message -----
> From: <rimi_doanksz@yahoo.com>
> To: "Belajar-access" <belajar-access@yahoogroups.com>
> Sent: Tuesday, May 22, 2012 2:19 PM
> Subject: [belajar-access] Report Jatuh Tempo
>
>
>> Dear Bapak2, Ibu2 dan Rekan2 semuanya...
>>
>> Bagaimana design Query dan Formnya, jika kita memasukkan range tgl jatuh
>> tempo pada form misalkan tgl awal 1 Mei 2012 dan tgl akhir 30 Mei 2012
>> report yg dihasilkan kira2 sperti berikut ini:
>>
>> Nama TglJT_SIUP TglJT_SITU TglJT_TDP
>> Adi 12 Mei 2012 16 Mei 2012 28 Mei 2012
>> Budi. - 20 Mei 2012 -
>> Ani 8 Mei 2012 - 18 Mei 2012
>> Joko 21 Mei 2012 3 Mei 2012 16 Mei 2012
>> Toni. - 9 Mei 2012 -
>>
>> Untuk report yg bertanda "-" berarti tgl jatuh tempo nya berada pada
>> bulan
>> lain...
>>
>> Saya kemarin sudah mendesign...tp report yg dihasilkan adalah sbb :
>>
>> Nama TglJT_SIUP TglJT_SITU TglJT_TDP
>> Adi 12 Mei 2012 16 Mei 2012 28 Mei 2012
>> Joko 21 Mei 2012 3 Mei 2012 16 Mei 2012
>>
>> Mohon pencerahan dari Bapak2, Ibu2 dan Rekan2 semua...
>>
>> Terima Kasih...
>>
>> Rimi Amelindo
>> Sent from my AXIS Worry Free BlackBerry® smartphone
>>
>> ------------------------------------
>>
>> SPAM IS PROHIBITEDYahoo! Groups Links
>>
>>
>>
>>
>
>
>
> ------------------------------------
>
> SPAM IS PROHIBITEDYahoo! Groups Links
>
>
>
>
>
>
>
> ------------------------------------
>
> SPAM IS PROHIBITEDYahoo! Groups Links
>
>
>
>


<*>Attachment(s) from Sofyan Efendi:


<*> 1 of 1 File(s) http://groups.yahoo.com/group/belajar-access/attachments/folder/188420105/item/list
<*> JATUH TEMPO PERIZINAN.rar

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/