If Sum = 0

[frankbutcher]

Hi All.
I have searched and searched for an answer to this one....no luck.
Others have posted the same sort of question, but no answers that I found are suitable.

I have a sub report within a report.
The sub report consists of fields from frmMaterial:-

Material (Drop Down)
Quantity
Costs
Total_Cost (Quantity * Costs)

There could be any number of materials within the sub report or no materials at all.
If there are no materials, then "#Error" appears in the total cost field.....so then that field cannot be used within the main report

I have tried setting the default values as 0 but this does not work.
I have also tried using nz for total cost and once again, no joy.

Can anyone show the way?

Thanks.

Frank.

 

[Rich]

Use the HasData method, you should be able to find examples here