Hi all,
I'm currently pulling out my already thin hair and need a little help
if possible. I have an Access 97 db that is used to store inspection
information for different regions. My report is meant to show the
number of inspections done in each region and what ratings they
achieved as below:
Region Green Yellow Red NR
Total
----------------------------------------------------------------------------------------------------------
North 5 1 0
12 18
South 0 6 0
9 15
East 3 3 3
1 10
Each value for green, yellow, red and NR is calculated from a "Count"
query as the data is stored as green, yellow, red or NR. The queries
are then attached to subreports which are then used in the main report
and the total is a text box adding the values contained in the
subreports. The problem as it stands is that if one of the subreports
doesn't return any value then it stays as a nul and causes an error in
my textbox calculation. Is there a way to make the subreports default
to zero instead of Null?
I've tried several things including IIf(IsNull(...) and NZ(...) but
can't seem to get this working so any help would be highly appreciated.
Many thanks, Dean...