subreport total showing error 1

[gimenes26]

I`v done a report with 3 subreports on the same page, each one showing separeted totals, but they are selected by week , for exemple if i select week number 27, the report shows me 3 records , if i select week 35 , the report shows me 7 records but sometimes we have weeks with no records , that is the problem if i select a week with no records the formula shows up whit error!! i need that formula showing with 0 for the grand total formula works ...any ideas please???

 

[dhookom]

If you want to pull a value from a text box on a subreport that might not have any data, you can use an expression like:
=IIf(srptMySub.Report.HasData, srptMySub.Report!txtTotal,0)

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]