Re: [belajar-access] Cara membuat report

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
>
>
>



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

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/