URGENT!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please HELP me! I have a query that returns this result:

ProjectName, Booked Revenue, ProjectExpense, NetRevenue

The Project Expense is subtracted from the Booked Revenue
in order to get the Net Revenue. My problem is that not
all Projects have expenses associated with them and the
the Booked Revenue is the Net Revenue but I can't get the
total to go into the Net Revenue column. Pleaseeeee help!

Thanks,
Karen
 
Please HELP me! I have a query that returns this result:

ProjectName, Booked Revenue, ProjectExpense, NetRevenue

The Project Expense is subtracted from the Booked Revenue
in order to get the Net Revenue. My problem is that not
all Projects have expenses associated with them and the
the Booked Revenue is the Net Revenue but I can't get the
total to go into the Net Revenue column. Pleaseeeee help!
Click to expand...

Use the Nz() function to zero-out the Null values in ProjectExpense. E.g.:

Nz(BookRevenue,0) - Nz(ProjectExpense,0) As NetRevenue
 
Back
Top