Hi,
I have a form with two DTPickers and i'd like to use them to filter my query and show it using a Crystal Report. I already designed the report and it works fine, but when i try the filter, it keeps showing all the records (up to 200) - and i'm sure the interval has only a few records (5)
This is what i'm trying:
Code:
wsql = "{ado.Inicio} IN Date(" & _
Format(DTVIncioDE.Value, "YYYY,MM,DD") & _
") TO Date(" & _
Format(DTInicioAte.Value, "YYYY,MM,DD") & ")"
With FrmCREDetalhadaCli 'auto generated Crystal Report Preview form
creDetalhadaCli.RecordSelectionFormula = wsql
.Show vbModal
End With
Thank u very much,
Dirso
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).