"Ryker" <ra*****@choctaw.org> wrote in
news:11*********************@i40g2000cwc.googlegro ups.com:
I have a Purchase Order where I have a calculated field called
Price that is calculated by multiplying Qty * Sales Price. I
have 10 of these fields...Price 1 - Price 10 (for each line of
the PO). The price fields are summed into another calculated
field of Total Price (for the whole purchase order). My
problem is that on the purchase order when there isn't
anything in lines 2-9, zeros print on the PO in the Sales
Price and Price fields(since there isn't anything to
calculate). Is there a way to suppress the printing of the
zeros?
Your table structure is not normalized and is causing your
problem.
The PO table should contain the common info, like DateOfOrder,
Buyer, Vendor, etc.
You need a child table for the POLine data, one for each line on
the given PO. It needs the PO_ID,Poline, Article,
SalesPrice,Price,Qty, and other niceties like promisedate,
You set a relation from PO (one) to POLine (many).
Then you only have the number of real lines showing up on your
form and report, so you don't get the calculated zeroes where
they don't belong.
--
Bob Quintal
PA is y I've altered my email address.