calculations forms and reports

D

datahunter

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!
 
E

Ed Metcalfe

datahunter said:
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!
Click to expand...

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.
 
J

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!
Click to expand...

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]
 
D

datahunter

math is done in the control source property.


Ed Metcalfe said:
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.
Click to expand...
 
D

datahunter

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
 
B

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!
Click to expand...

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

HTH
Bubbles
 
J

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
Click to expand...

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]
 
Top