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
Conditional DB reports 3
Null Is Null 13
Count on the page 1
select text from an option group 2
Record Source not showing field names 4

Top