M
Melinda
I had posted this message earlier, but didn't receive an answer, thought I
would try again. I have a Purchase Order database, within this data base I
have a form where you can input material that will be charged against a
paticular purchase order.
I am putting together a report that will show all purchase order balances
and the material charged against them. Where I am running into a problem is
when there is no material charged against a purchase order it does not show
up in report. The minute I charge material against it, boom it pops into
the report. If there is no material charged to the purchase order I
would like it to just populate the encumbered amount, so that it does indeed
reflect that purchase order in the report. I have tried "Null", but I
don't think that is the answer because back in the receiving ticket table
nothing exists because we have not purchased anything on the purchase order.
Any help would be greatly appreciated.
would try again. I have a Purchase Order database, within this data base I
have a form where you can input material that will be charged against a
paticular purchase order.
I am putting together a report that will show all purchase order balances
and the material charged against them. Where I am running into a problem is
when there is no material charged against a purchase order it does not show
up in report. The minute I charge material against it, boom it pops into
the report. If there is no material charged to the purchase order I
would like it to just populate the encumbered amount, so that it does indeed
reflect that purchase order in the report. I have tried "Null", but I
don't think that is the answer because back in the receiving ticket table
nothing exists because we have not purchased anything on the purchase order.
Any help would be greatly appreciated.