receipt error

[Ankit.Patel.UK]

hello,

the problem i am receiving is that i can't work the subtotal pf my
receipt out. Basically i have a receipt with various details on such as
product,quantity,unit price,extended price. My problem is that i can't
work out the subtotal. I have code already in the extendedprice box
which works out the price depending on the quantity wanted:
'=[Quantity]*[Unit Price]'. When i write the following code for the
subtotal box :'=Sum([extendedprice])' i seem to receieve an error
message in teh subtotal box'#error' when i view the form.

all info and help would be smashing.

 

[Kevin McCartney]

Hi Ankit,

I think if you look at the individual records that are used in the sum, e.g.
if you look at the continuous form, one or more of your records may have a
null value in one of the fields that you using in the summation, e.g.
=[Quantity]*[Unit Price]

=[10]*[] would result in an error and your summation
=Sum([extendedprice])located in the form footer can't sum up the individual
fields. Alternatively is extendedprice a field name or a text box name, to
distinquise between the two but the preceeding txt text box naming convention
at the start of the text name and then in the summation formula it would be
=Sum([txtextendedprice]).

HTH
KM

 

[Kevin McCartney]

Ooops my mistake the summation formaula is to remain the
=Sum([extendedprice]), =Sum([txtextendedprice]) won't work.

sorry
KM

Hi Ankit,

I think if you look at the individual records that are used in the sum, e.g.
if you look at the continuous form, one or more of your records may have a
null value in one of the fields that you using in the summation, e.g.
=[Quantity]*[Unit Price]

=[10]*[] would result in an error and your summation
=Sum([extendedprice])located in the form footer can't sum up the individual
fields. Alternatively is extendedprice a field name or a text box name, to
distinquise between the two but the preceeding txt text box naming convention
at the start of the text name and then in the summation formula it would be
=Sum([txtextendedprice]).

HTH
KM

hello,

the problem i am receiving is that i can't work the subtotal pf my
receipt out. Basically i have a receipt with various details on such as
product,quantity,unit price,extended price. My problem is that i can't
work out the subtotal. I have code already in the extendedprice box
which works out the price depending on the quantity wanted:
'=[Quantity]*[Unit Price]'. When i write the following code for the
subtotal box :'=Sum([extendedprice])' i seem to receieve an error
message in teh subtotal box'#error' when i view the form.

all info and help would be smashing.