calculations forms and reports

[Guest]

I am not sure why but i have a form with a calculation that has been done...
finale balance... and i want to bring this value into my report, the problem
is that access 2007 report just stays blank in the field where the final
value calc is. how do i inport this final value into my report. Thanks for
the help!

 

[Ed Metcalfe]

I am not sure why but i have a form with a calculation that has been
done...
finale balance... and i want to bring this value into my report, the
problem
is that access 2007 report just stays blank in the field where the final
value calc is. how do i inport this final value into my report. Thanks
for
the help!

Where are you performing your calculation? In a query, or in an expression
in the control source property? Are you saving it to your table?

Ed Metcalfe.

 

[John W. Vinson]

I am not sure why but i have a form with a calculation that has been done...
finale balance... and i want to bring this value into my report, the problem
is that access 2007 report just stays blank in the field where the final
value calc is. how do i inport this final value into my report. Thanks for
the help!

The calculated field on the form *is just that* - a calculation displayed on
the form. It's not, and should not be, stored anywhere in your tables.

Just redo the calculation on the Report, or in a query upon which you base
both the form and the report.

John W. Vinson [MVP]

 

[Guest]

math is done in the control source property.

Where are you performing your calculation? In a query, or in an expression
in the control source property? Are you saving it to your table?

Ed Metcalfe.

 

[Guest]

im not sure how to make a calc in a quary... 2007 is vary new to me and had
limited exp with early vers... thanks

 

[bubbles]

I am not sure why but i have a form with a calculation that has been done...
finale balance... and i want to bring this value into my report, the problem
is that access 2007 report just stays blank in the field where the final
value calc is. how do i inport this final value into my report. Thanks for
the help!

Try out the report wizard.
It allows you to do various calculations like Sum and Percent.

HTH
Bubbles

 

[John W. Vinson]

im not sure how to make a calc in a quary... 2007 is vary new to me and had
limited exp with early vers... thanks

If you have a textbox on a form with a control source like

=<some expression>

open the Query in design view and find a vacant Field cell; type in it

SomeFieldName: <some expression>

using the same expression. You can then use SomeFieldName as the control
source of a form or report textbox.

John W. Vinson [MVP]