I am not sure of the best way to do this and I'm hoping someone can help me. I have a database listing parts that we have ordered. In my parts table I have a column called QTY and a column called RECD_DATE. What I want to do is create a way to say the following:
1. how many of part x have we ordered (I have gotten this total by doing a
SUM[(QTY)] on the report from my original query.
2. how many of part x have come in (in my query I put "is not null" in the RECD_DATE column)
here's where it stumps me:
3. total ordered minus qty received = number of outstanding parts. For the life of me I cannot figure out how to get it to do a sum of the parts when the RECD_DATE column is null. i.e. SUM([QTY]) when RECD_DATE is not null
I'm not sure if the best way to do it is multiple queires or expressions on the report? Does that make any sense?