I am working on a query that adds up amounts based on what is in the column. i.e. Add up Rental Amts that have a W in the next column. The problem is when there is not a W in the rental amt column I need to have it return zero or some other place keeper.

>The problem is when there is not a W in the rental amt column I need to have it return zero or some other place keeper<

You can use the IIF function or the NZ function to achieve your goal.
Look it up in Access Help, try it out,come back if you need further assistance.

RV

I used the following IIF statement with no results. IIf([Whole]=null,[Rental Amt]=0,[Rental Amt])

It may give you a better idea of what I am trying to do.

=Iif(IsNull([Whole],0,[Rental Amt]))

This does not work as access says there are not enough operators. I guess I don't see how this will accomplish what I want.