Saya nyambung dari apa ditanyakan .... 
Saya pake database access, cr 8.5 
Saya pake range tanggal menggunakan sintaks query 'between #dd/mm/yyyy#
and #dd/mm/yyyy#' ... datanya tdk dapat muncul pdhl data dengan range
tanggal yang di select itu bisa .... knpa, ya? 

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ndari
Sent: Saturday, August 20, 2005 2:10 PM
To: [EMAIL PROTECTED]
Subject: [Programmer-VB] tanya date time

hai friends

tanya nih,
kalo aku pake database MS SQL2000
lalu reportnya pake Crystal Report 8.5.

bagaimana format nampilin
data antara tgl dd-mm-yyyy s/d
tgl dd-mm-yyyy. 
pakai "CR.SelectionFormula" 

udah kucoba  di CR pake 
CrystalReport1.SelectionFormula = 
"{mpeg_tbl.mpeg_lupd} = #" &
dpakhir.Value & "#" 
....dst.

kok muncul error:
Run-time error '20515';
error in formula .
'{mpeg_tbl.mpeg_lupdt}=#8/15/2005#' ...dst
A number, currency amount, boolean or string is
expected here.

sorry baru belajar VB
thank before




Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]

 
Yahoo! Groups Links



 





------------------------ Yahoo! Groups Sponsor --------------------~--> 
<font face=arial size=-1><a 
href="http://us.ard.yahoo.com/SIG=12hcpd9jt/M=362131.6882499.7825260.1510227/D=groups/S=1705115364:TM/Y=YAHOO/EXP=1124681232/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life 
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~-> 

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Programmer-VB/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Kirim email ke