No record showing error

[gimenes2603]

hi, how to make my text showing 0 when there is no record?
I have a report with 3 subreports , with the total of all. But if one subreports has no record, comes up with #error...
What do i have to do to show 0 ?
i tried this but is not working :

=SeImed([Conservatory Job].[Relatório]![Texto95]="",0,[Conservatory Job].[Relatório]![Texto95])

Thanks

 

[dhookom]

The typical syntax is like:
=IIf(subrptA.Report.HasData, subrptA.Report.txtBoxName,0)
You will need to change the name of subrprtA and txtBoxName to match yours and also include the other subreport references.

While you are working on this, you might want to change the name of your text box to something that is understandable rather than "Texto95".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]