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/