how to retrieve records (date/time) whose value is blank

[FernandoAndrade]

Hi Everyone

Im programming in Visual Basic 6, Access 2000 and Crystal Reports 8.5 Developer Edition.
I have a table which contains a field called "fechaenvio" (date/time) and I need to know how to retrieve (using the Crystal Reports selectionformulas), all records whose value of the field "fechaenvio" is blank. (or empty)

Example :

reporte.ReportFileName = "\\host\folder\report.rpt"
reporte.SelectionFormula = "{table.fechaenvio}= ' ' " (do not work)

reporte.DiscardSavedData = True
reporte.Destination = crptToWindow
reporte.WindowState = crptMaximized
reporte.Action = 1

Thanks

Fernando Andrade
Santiago Chile

 

[dgillz]

I am not sure how to rexpress this in VB, but the crystal syntax is as follows:

isnull({table.fechaenvio})

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[FernandoAndrade]

dgillz, your option works !!!!

reporte.ReportFileName = "\\host\folder\report.rpt"

reporte.SelectionFormula = "isnull({table.field})"

reporte.DiscardSavedData = True
reporte.Destination = crptToWindow
reporte.WindowState = crptMaximized
reporte.Action = 1

thank you for the reply. It is greatly appreciated

regards
Fernando