Jumat, 26 April 2013

Re: [belajar-access] Cara membuat report

Dear all
@pak aksan, td sy bertanya query itu apa, skrng saya sdkt paham fungsi query.
@all : Dr case yg saya kirimkan, table tersebut akan diisi setiap harinya, secara otomatis setiap hari tanggal dan bulan akan berbeda, bagaimana menampilkan di report agar dapat dipilih bulan dan tanggal tertentu saja, apakah perlu ditambah table lainnya. ?
Mohon pencerahaanya, step by step ya, agar saya juga bisa belajar access
Terima kasih sebelumnya
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/

Tidak ada komentar:

Posting Komentar