I have a master report with 2 sub reports all tied together based on Employee
#. It is a report for payroll, it adds totals from all three reports for a
grand total. The problem I have is sometimes when a subreport is not created
for an employee my grand total shows Error.

Main Report               all sales
sub         expenses
sub        Bonus

We should always have sales, but expenses and bonus differ on each pay
period, sometimes a employee may not have a bonus or expenses. When this
happens I get error msg I my grand total. Any suggestions to fix would be
appreciated.

Grand total = [allsales]+[subreport]![expenses]-[subreport1]![Bonus]

again everthing works when all three reports have totals.