i have created a report with a number of sub-reports which all show figures.
example sales invoice total
sales credit total
purchase invoice total
purchase credit total.
all four of the above have just a summery of their individual totals, which are added/subtracted together to give an actual profit figure.
the data is kept in individual tables.
the problem i am having is if there are no credit notes for instance the text box with the grand total is empty due to there being no data in the credit note summery field, i believe that i can use the "iif" or "nz" commands to change the null value to a "0.00" which i think will allow the sum to function properly. can anyone tell me how i should type the line of criteria as i have tried any number of ways and just dont seem to be able to crack it.