Null report still needs output

Hello All,

I have a report for a database I've been working on for 6 months. It is populated by a query that filters on a field being populated. If there are no records which fulfill this condition, the report totals at the bottom evaluate to #error. This makes sense: there is no data for the report to work with. The porblem is that I need the report to not give errors - it needs to say something like "There is no data available for this report". I'd hoped that the "iserror" function, thrown is with something like a iif statement in the report totals, might handle this. Unfortunatly, this didn't work (it still returned an '#error'). Does anyone know of a way around this? If you need clarification (I realize I speaking a little vaguely here), please let me know.

Nick

Use an expression like:
=IIf([HasData],Sum([YourField]),0)

--
Duane Hookom
MS Access MVP


"Shinankoku" wrote in message
...
Hello All,

I have a report for a database I've been working on for 6 months. It is
populated by a query that filters on a field being populated. If there are
no records which fulfill this condition, the report totals at the bottom
evaluate to #error. This makes sense: there is no data for the report to
work with. The porblem is that I need the report to not give errors - it
needs to say something like "There is no data available for this report".
I'd hoped that the "iserror" function, thrown is with something like a iif
statement in the report totals, might handle this. Unfortunatly, this
didn't work (it still returned an '#error'). Does anyone know of a way
around this? If you need clarification (I realize I speaking a little
vaguely here), please let me know.

Nick