form sum calculation error

[vg-mail]

Hello all,

I have identical design for form and report but I am getting
calculation error on form and everything is OK on report. The form and
report are build up on SQL statement. The calculation is very simple.
The calculation is done in an underling query if I can call it a query
or I should call it a SQL statement. It looks like a query but it is
not saved as the query. The calculation in that query is very simple -
ExtendedPrice:[Price]*[QTY]. Then I have a field as follows:
=Sum([ExtendedPrice]) and it is OK on report but it returns error on
form. The funny think that when I tried differnt expression and
approaches this expression returns number after a change. But as soon
as form is saved and opened again it displays Error. Any idea that I
have wrong?

[salad]

vg*****@telus.net wrote:

Hello all,

I have identical design for form and report but I am getting
calculation error on form and everything is OK on report. The form and
report are build up on SQL statement. The calculation is very simple.
The calculation is done in an underling query if I can call it a query
or I should call it a SQL statement. It looks like a query but it is
not saved as the query. The calculation in that query is very simple -
ExtendedPrice:[Price]*[QTY]. Then I have a field as follows:
=Sum([ExtendedPrice]) and it is OK on report but it returns error on
form. The funny think that when I tried differnt expression and
approaches this expression returns number after a change. But as soon
as form is saved and opened again it displays Error. Any idea that I
have wrong?

What happens if you enter Sum([Price]*[QTY]) in the form instead?

[Rich P]

check the form's recordsource property. You need to bind your form to
the table or query that contains the field ExtendedPrice. Make that
table or query the recordsource for the form. In order to use this kind
of expression on a textbox on a form, the form must have a corresponding
recorsource to pull the data from. Then place the expression

=Sum([ExtendedPrice])

in the ControlSource of an unbound textbox. That should fix your
problem.
Rich

*** Sent via Developersdex http://www.developersdex.com ***

[vg-mail]

I tried to bound calculated field and I tried to do calculation like
that. In both cases I have Error. But when I open form and do first
time changes for example from =Sum([Price]*[QTY]) to
=Sum([ExtendedPrice]) I am getting results. As soon as form saved and
opened again the Error is coming back. I wonder if some of the form
property effects it. With formulas I am Ok as the same formulas are
used in invoice report and report works well. Is there something in
calculation that you can do in report but you can not do in form?
Thanks/ Vadim
salad wrote:

vg*****@telus.net wrote:

Hello all,

I have identical design for form and report but I am getting
calculation error on form and everything is OK on report. The form and
report are build up on SQL statement. The calculation is very simple.
The calculation is done in an underling query if I can call it a query
or I should call it a SQL statement. It looks like a query but it is
not saved as the query. The calculation in that query is very simple -
ExtendedPrice:[Price]*[QTY]. Then I have a field as follows:
=Sum([ExtendedPrice]) and it is OK on report but it returns error on
form. The funny think that when I tried differnt expression and
approaches this expression returns number after a change. But as soon
as form is saved and opened again it displays Error. Any idea that I
have wrong?

What happens if you enter Sum([Price]*[QTY]) in the form instead?

[Rich P]

Try an experiment. Create a new form just with one text box and all the
properties of the form are default properties. Set the recordsource of
that form to the table/query that has the data you need to calculate.
In the textbox enter your calculated expression

=Sum([ExtendedPrice])
Open the form and see if that works. Then save the new form and re-open
it to see if it still works. If it works then you can start modifying
the form to your needs. Each time you make a change to the form - open
the form to see if it still works. After a change, if you get an Error
message in the textbox, then make a note of the change you made after
you receive the Error message in the textbox. That change is what is
causing your problem. Then, if you can't figure out what the problem
is, you can post the change that you made after you receive the Error
message.

Rich

*** Sent via Developersdex http://www.developersdex.com ***