Data Report help Please

Hi

I have been battling this problem for about 3 weeks now, and it has to be possible. I am using the VB6 DataReport and have created the report with the dateEnvironment and the report works like a charm, but i only need it to show the Customer Names that match the current date, i have a date field with the correct date format, but still it prints every customer in the database. Please can someone help me.


Many thanks

Set your data environment command to get its record source from a SQL statement (not a table name) if you haven't already. Then in your SQL statement, include something like this:

WHERE table.datefield = getdate()

getdate() returns the current date.

Hope this helps,
Darrell