Mungkin ini bisa bermanfaat dim sql$
sql = "Select * from Database where CI LIKE 'JS%' ----- Original Message ----- From: adie putra To: [email protected] Sent: Friday, January 19, 2007 2:12 PM Subject: [Programmer-VB] Report database Dear All, Saya mo tanya tentang report cr 8.5, bagaimana caranya untuk memfilter field CI berdasarkan 2 huruf didepan. contoh : - Database : File_Date BSS_Name CI Area RACH Succ Rate 09-Nov-06 BJK16 JS06058 Dense_Urban 99.99% 10-Nov-06 BJK16 JS06094 Dense_Urban 99.99% 11-Nov-06 BJK16 DP06058 Dense_Urban 99.95% 12-Nov-06 BJK16 DP06090 Dense_Urban 99.90% 13-Nov-06 BJK16 JS06054 Dense_Urban 99.98% 14-Nov-06 BJK16 BG06058 Dense_Urban 100.00% 15-Nov-06 BJK16 JU06058 Dense_Urban 99.96% 16-Nov-06 BJK16 JP06050 Dense_Urban 99.99% 17-Nov-06 BJK16 JP06052 Dense_Urban 99.97% 18-Nov-06 BJK16 JB06058 Dense_Urban 99.88% 19-Nov-06 BJK16 JT06058 Dense_Urban 100.00% 20-Nov-06 BJK16 JP06058 Dense_Urban 100.00% 21-Nov-06 BJK16 JB06058 Dense_Urban 99.99% 22-Nov-06 BJK16 BG06058 Dense_Urban 99.96% 23-Nov-06 BJK16 JS06058 Dense_Urban 99.99% 24-Nov-06 BJK16 JS06058 Dense_Urban 99.97% 25-Nov-06 BJK16 JS06058 Dense_Urban 99.95% 26-Nov-06 BJK16 JS06058 Dense_Urban 99.82% 27-Nov-06 BJK16 JS06058 Dense_Urban 99.97% 28-Nov-06 BJK16 JS06058 Dense_Urban 99.97% 29-Nov-06 BJK16 JS06058 Dense_Urban 100.00% 30-Nov-06 BJK16 JS06058 Dense_Urban 99.98% 01-Dec-06 BJK16 JS06058 Dense_Urban 99.96% 02-Dec-06 BJK16 JS06058 Dense_Urban 99.95% 03-Dec-06 BJK16 JS06058 Dense_Urban 99.85% 04-Dec-06 BJK16 JS06058 Dense_Urban 100.00% 05-Dec-06 BJK16 JS06058 Dense_Urban 99.96% 06-Dec-06 BJK16 JS06058 Dense_Urban 99.97% 07-Dec-06 BJK16 JS06058 Dense_Urban 99.99% 08-Dec-06 BJK16 JS06058 Dense_Urban 100.00% 09-Dec-06 BJK16 JS06058 Dense_Urban 99.90% Atas saran dan masukan serta bantuannya saya ucapkan terima kasih. Adie Putra ------------------------------------------------------------------------------ The fish are biting. Get more visitors on your site using Yahoo! Search Marketing.
