0

in data environment i write

Select * from item where date and date between DTFr.value and DTTo.vlaue

In button I write

Load DataEnvironment1
    With DataEnvironment1
    If .rscmborder.State <> 0 Then .rscmborder.Close
     .cmborder Format(DTFr.Value, "dd/mm/yyyy"), Format(DTTo.Value, "dd/mm/yyyy")
     End With
     drorder.Show

but the report show all item from 1st date. it not show the range of date. (What I selected)

3
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by AndreRet
0

Hi,

In D.Env, u have to write:
Select * from item where date and date between ? and ?

Then select appropriate type in parameter list..

Regards
Veena

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.