receipt error

  • Thread starter Thread starter Ankit.Patel.UK
  • Start date Start date
A

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.
 
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
 
Ooops my mistake the summation formaula is to remain the
=Sum([extendedprice]), =Sum([txtextendedprice]) won't work.

sorry
KM

Kevin McCartney said:
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

[email protected] said:
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.
Click to expand...
Click to expand...
 
Back
Top