Data Report help Please

[alexanderjames]

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

[delunsford]

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