URGENT!

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
 
M

MGFoster

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting wrong information in query 6
URGENT!! Using IIF in query 6
Make table query where INTO {tablename} is actually a parameter; doesn't work 2
ranking two reports 1
using a "for" loop in a query to reference data from another table 14
Apply curve to results of query 3
Top X Values Per Quarter 3
Calculate Revenue based on dates within a month 4

Top