#Error Message on Report

[Guest]

I am sure that this question has been asked b4; however, i cannot seem to
find the answer. So, if someone does not mind answering again for me i would
appreciate it.

My problem/question is:
In each consultant's report i have the following fldnames
client dept program billable days days used
remaining billable days
remaining days is a calculated field: (billable days - days used)=remaining
billable days
i used the report wizard to set up my report and in doing so i opted for the
summary and detail information. i have a monthbilled header and footer. the
monthbilled footer sums the billable days and days used and counts the
records. and again i get the #error message.

i did place an unbound text box in the detail section with the expr:
=IIf(IsNull([fldname]),0,[fldname]) with this i do not get the #error nor a
zero.

i have tried Nz([fldname])+Nz([fldname]); however, when i enter test
information in the monthbilled footer total is double (i.e. 6 billable hrs
instead of 3 billable hrs). the grand total is correct, 3 billable hrs.
i also get an #error in the summary for count instead of "no data reported"
i just want the report to either show zeroes or left blank if there is no data

please help

 

[Guest]

I found an expression that seemed to help; however, i still need help...PLEASE.

The expression i found was =IIf([hasdata],[amt],0) and
IIf([hasdata],sum([detailamt]),0)
I used this expression on my report in my calculated fld, as such:
=IIf(HasData],[VBD],0) and IIf([HasData],Sum([VBD]),0)

Now this worked when there was no data but when i put in test data in the
summaryfooter, count records and the grand total footer i get a negative 1.
Please help me what am i doing wrong.