Buat Query dengan data Query [Cycle Time]. Lihat gambar diatas sbg petunjuk . hasil sql nya :
SELECT [Cycle Time].[F-CODE], Avg([Cycle Time].[C/T1]) AS [AvgOfC/T1]
FROM [Cycle Time]
GROUP BY [Cycle Time].[F-CODE];
Semoga berguna
From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of budi_secbtm@sanyo.com
Sent: Saturday, August 20, 2011 11:28 AM
To: belajar-access@yahoogroups.com
Subject: [belajar-access] Nilai Rata-2 [1 Attachment]
[Attachment(s) from budi_secbtm@sanyo.com included below]
Dear Pakar Access,
Gimana cara membuat formula mencari nilai rata-2 di access? Maklum masih pemula
Oya dimana ya bisa saya dapatkan contoh formula-2 yang dipakai diaccess ? sebab kalau pakai help yang diaccess masih kurang contoh-2 pengunaan formulanya
Thank & Best Regards
Budi
BAT-MR
PT. SANYO Energy Batam
Jl. Beringin Lot 11, Batamindo Industrial Park
Muka Kuning, Batam , Indonesia 29433
Tel : +62-770-611321 ext 232
No comments:
Post a Comment