> I'm working on a report where the SQL string's values are determined
> at runtime, based on user choices (code is below).  In the de{*filter*}, I
> added watches for strSQL, startDate, endDate and those values are
> getting set the way I expect them to.  However, the report is
> displaying all of the records in my table.  I believe I have to set
> something up in the report to handle the SQL string but I have no idea
> where to do this.  Could  someone please tell me how to do this?  I'd
> greatly appreciate someone's help.  Thanks in advance.

>     Dim strSQL As String
>     Data1.DatabaseName = App.Path & "\Development Log.mdb"
>     Data1.RecordsetType = 1

>     startDate = DTStart.Value
>     endDate = DTEnd.Value

>     strSQL = "SELECT * "
>     strSQL = strSQL & "FROM LogComments "
>     strSQL = strSQL & "WHERE LogComments.[Work Date] >= " & startDate
>     strSQL = strSQL & " And LogComments.[Work Date] <= " & endDate
>     CrystalReport1.SQLQuery = strSQL
>     'Opening the report in preview mode
>     CrystalReport1.Action = 0

> Molly J. Fagan

> Sent via Deja.com http://www.*-*-*.com/
> Before you buy.