Zero suppression in a report on calculated fields

[Ryker]

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?

[fredg]

On 3 Apr 2006 12:30:49 -0700, Ryker wrote:

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?

You can use the Control's Format property to suppress 0's.
Set the Format property to:
#,##0.00;-#,##0.00,""

See Access help
Format Property + Number and Currency datatypes
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Bob Quintal]

"Ryker" <ra*****@chocta w.org> wrote in
news:11******** *************@i 40g2000cwc.goog legroups.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,Pric e,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.