[RESOLVED] Strange Problem (Crystal Report 9)

[artstar]

Hello:

I have a strange problem. Please take a look at my access table my report gets it's information from. As you can see there are 18 records, and my report will show 18 lines of information but incorrect. I used two DTPickers to select start date and end date for the report information That part works.

My record selection forumla is
Report.RecordSelectionFormula = "{Stackers.LocID}= " & DataCombo1.BoundText & " and {Location.ID}= " & DataCombo1.BoundText & " and {Machines.enable}=True " & " and cdate({stackers.INdate})>= " & Chr$(35) & dtp1 & Chr$(35) & " and cdate({stackers.INdate})<= " & Chr$(35) & dtp2 & Chr$(35) ' String variable has to be enclosed in ' '

Any Ideas