Re: [belajar-access] Cara membuat report

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

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