returning a text when value is NULL.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

order on the months 3
order on the months. 4
form criteria 4
set a blank printer to a report 1
Access Determine what query to run based on a checkbox 0
change default printer of a report 10
Null Is Null 13
If Null - Display Text 7

Top