Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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.
 
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.
 
Back
Top