returning a text when value is NULL.

  • Thread starter Thread starter Rodolfo Fontes
  • Start date Start date
R

Rodolfo Fontes

Hi group,

I have a form that when a date is selected, it appears on the report.
I wanna return a wod ("ALL") when no date is selected.
I've used the following code to select the date:
="Quantidade de Crimes entre: " & Formulários![F
Relatorio_Completo]!txtData_I & " - " & Formulários![F
Relatorio_Completo]!txtData_F
How can I return a text when no date is selected?

Thanks,
Rodolfo Fontes
 
Back
Top