i am having a form in vb 6.0 that gets the data from an access database between dates in dtpicker1 and dtpicker2 . now i want to display this data in a report i am having cr 8.0 . and i am using the following record selection formula for that but the output is a blank report plz tell me the solution.

VB Code:
  1. rpt.RecordSelectionFormula = "{DATA.invd}>   #" & Format$(Form27.DTPicker1.Value, "mm-dd-yyyy") & "#  AND {data.invd} < #" & Format$(Form27.DTPicker2.Value, "mm-dd-yyyy") & " #"