Manipulate field in detail section from datareport

[nico_van_wijk]

I have a designed a datareport in VB6. In the detail section is a date field. For each record where the date is bigger then the today-date I will display a * behind the date field on the report.

Is this possible? Maybe it's possible with the SQL command, something like:

Select *, date2(if date > now then date = date + "*" from Table;