Crystal report - between two dates

[sterankin]

I am using VB6 with crystal reports 9.
I have this SQL statement as a command in crystal reports.


SELECT DISTINCT Samplepoint, TestType, SUM(Result)
FROM Daily WHERE Result <> 'none'
GROUP by SamplePoint, TestType

On my VB form, the user will select two dates to search between, and only results that occur between those two dates will be displayed on the crystal report.

How would I do this?

Can VB change the crystal report SQL command at runtime?

Many Thanks

[Pasvorto]

How about this...

SELECT DISTINCT Samplepoint, TestType, SUM(Result)
FROM Daily WHERE Result <> 'none'
and Date <= EndDateEntered
and Date >= StartDateEntered
GROUP by SamplePoint, TestType