Jumat, 26 April 2013

Re: [belajar-access] Cara membuat report [1 Attachment]

<*>[Attachment(s) from aksan kurdin included below]

Ah, ini dapat linknya:

http://www.rumahaccess.com/2012/12/buku-panduan-lengkap-access-2010.html

mudah2an stoknya masih ada.
kalau sudah habis, bang haji ... apa ga dicetak lagi ?
kalau sudah ga dicetak lagi, boleh dong buat ebook aja :) kudu ijin elex
ya ?


aksan kurdin

On 4/27/2013 4:18 AM, aksan kurdin wrote:
> kalau pelajaran teori, sebaiknya beli buku access saja kyla.
> saya sarankan terbitan gramedia buku dari bang haer talib. lengkap
> isinya. harganya ga begitu mahal.
> judul bukunya apa ya bang haji? dasar2 access 2010 ya ?
>
> lalu kenapa ada baris yang misah ?
> :)
> coba teliti di databasenya/tabelnya kyla. NIK sama-sama 10008849,
> begitu juga nama dan section sama, tetapi di tanggal 8/1 itu,
> jabatannya berubah jadi Operator FM 12.
>
> aksan kurdin
>
> On 4/26/2013 2:29 PM, kyla_delv@yahoo.com wrote:
>> Query... Itu fungsinya apa ya pak?
>> Mengapa terpisah baris antara tgl 8 januari dengan tanggal lainnya ya
>> pak?
>> Mohon penjelasannya
>> Terima kasih
>> Salam
>> Kyla
>> Powered by Telkomsel BlackBerry®
>>
>> -----Original Message-----
>> From: aksan kurdin <aksan.kurdin@gmail.com>
>> Sender: belajar-access@yahoogroups.com
>> Date: Fri, 26 Apr 2013 14:06:25
>> To: <belajar-access@yahoogroups.com>
>> Reply-To: belajar-access@yahoogroups.com
>> Subject: Re: [belajar-access] Cara membuat report
>>
>> sudah masuk level expert, kyla.
>> bekerjanya bukan dengan report, tetapi query.
>>
>> 1. crosstab query:
>> TRANSFORM Last(Sheet1.CODE) AS LastOfCODE
>> SELECT Sheet1.NIK, Sheet1.Nama, Sheet1.Jabatan, Sheet1.Section
>> FROM Sheet1
>> GROUP BY Sheet1.NIK, Sheet1.Nama, Sheet1.Jabatan, Sheet1.Section
>> PIVOT Sheet1.Tanggal;
>>
>>
>>
>> 2. select query:
>> SELECT Sheet1.NIK, Sheet1.Nama, Sheet1.Jabatan, Sheet1.Section,
>> Sum(IIf([Code]="H",1,0)) AS H, Sum(IIf([Code]="S",1,0)) AS S,
>> Sum(IIf([Code]="I",1,0)) AS I, Sum(IIf([Code]="A",1,0)) AS A,
>> Sum(IIf([Code]="CT",1,0)) AS CT, Sum(1) AS Total
>> FROM Sheet1
>> GROUP BY Sheet1.NIK, Sheet1.Nama, Sheet1.Jabatan, Sheet1.Section;
>>
>>
>>
>>
>> aksan kurdin
>>
>> On 4/26/2013 12:10 PM, kyla_delv@yahoo.com wrote:
>>> Dear All,
>>> Bisa tolong saya diajarkan bagaimana membuat report seperti data yg
>>> terlampir di format excell
>>> Saya baru bisa membuat table saja, untuk yg lain2nya belum paham,
>>> mohon bimbingannya
>>> Terima kasih
>>> Salam
>>> Kyla
>>> Powered by Telkomsel BlackBerry®
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>> SPAM IS PROHIBITEDYahoo! Groups Links
>>>
>>>
>>>
>>
>>
>>
>> ------------------------------------
>>
>> SPAM IS PROHIBITEDYahoo! Groups Links
>>
>>
>>
>



<*>Attachment(s) from aksan kurdin:


<*> 1 of 1 File(s) http://groups.yahoo.com/group/belajar-access/attachments/folder/1642266654/item/list
<*> PANDUAN LENGKAP MICROSOFT ACCESS 2010.pdf

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

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/

Tidak ada komentar:

Posting Komentar