Calculations

N

nbuwalda

I have calculations setup within my quiries and when info is inputted into my
forms the output only shows on my forms. So how do I create a report that
will show the output since access doesnt let you create reports from forms?
 
R

Rick B

Build those same calculations in your reports (just like you did on your
forms).




nbuwalda said:
I have calculations setup within my quiries and when info is inputted into my
forms the output only shows on my forms. So how do I create a report that
will show the output since access doesnt let you create reports from
Click to expand...
forms?
 
N

nbuwalda

The only way I know how to do calculations in reports is with the Expression
Builder. Thru this I located my form and add my 2 fields to subtract but it
still didnt work. Is there another way to do calculations? On my report all
I want is Product Name and the calculated field.
 
J

Jeff Boyce

The calculations you can do in a control on a form, you can probably also do
in a control on a report, as Rick suggested.

Another approach would be to do the calculations in a query, then use that
query to display in your form and report.
 
Top