Re: [belajar-access] Cara membuat report

Ikut nimbrung juga, saya yang sedang belajar Access, yang juga mendalami SQL tetapi belum banyak mengerti.

Terima kasih om Aksan Kurdin atas pencerahan SQL-nya.

Untuk Kyla, dapat diaplikasikan SQL dari om Aksan Kurdin tanpa harus mengerti terlebih dahulu artinya.
Caranya buka di ribbon CREATE, pilih Query Design, setelah terbuka pilih table sheet-nya lanjutkan dengan pilih di ribbon DESIGN, pilih View lalu SQL View, selanjutnya copykan SQL yang dari om Aksan Kurdin dan paste-kan di area kerja SQL View :

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;

dannn... pilih Datasheet View.... eng i eng jadilah sudah.... Ulangi kembali langkah berikut untuk SQL ke dua yang sudah dibuat om Aksan Kurdin.

mmmm luar biasa, salam kenal dan terima kasih om Aksan Kurdin atas pencerahannya yang juga membantu saya dalam belajar SQL Access.

Salam,
Anang

---

From: aksan kurdin <aksan.kurdin@gmail.com>
To: belajar-access@yahoogroups.com
Sent: Friday, April 26, 2013 2:06 PM
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:

<*>[Attachment(s) from kyla_delv@yahoo.com included below]    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®    <*>Attachment(s) from kyla_delv@yahoo.com:      <*> 2 of 2 File(s) http://groups.yahoo.com/group/belajar-access/attachments/folder/1217905724/item/list     <*> bELAJAR aCCESS.accdb    <*> Report yg diinginkan.xls    ------------------------------------    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/