M
Melinda
I have a purchase order report which I want to list all purchase orders and
their respective balances. I have an encumbered amount, a modification
amount, and a totalcost of material that has been spent against that purchase
order. I am having trouble with null values. I had posted something
similar to this earlier, but it is still not working. I will always have an
encumbered amount, sometimes a modification and at times when I run the run
the report there will be not materials charged against that purchase order.
I have the [quantity]*[priceperunit] for the total cost. It reflects the
purchase orders that have material charged against them, but the purchase
orders with only an encumbered amount does not show up in the report. I
have an unbound text box with this in the control source:
=([encumbered]+Nz([sumofmodamount],0)-sum(Nz([totalcost])))
As soon as a assign material (totalcost) against the purchase order it shows
up in the report. Any help would be appreciated.
their respective balances. I have an encumbered amount, a modification
amount, and a totalcost of material that has been spent against that purchase
order. I am having trouble with null values. I had posted something
similar to this earlier, but it is still not working. I will always have an
encumbered amount, sometimes a modification and at times when I run the run
the report there will be not materials charged against that purchase order.
I have the [quantity]*[priceperunit] for the total cost. It reflects the
purchase orders that have material charged against them, but the purchase
orders with only an encumbered amount does not show up in the report. I
have an unbound text box with this in the control source:
=([encumbered]+Nz([sumofmodamount],0)-sum(Nz([totalcost])))
As soon as a assign material (totalcost) against the purchase order it shows
up in the report. Any help would be appreciated.