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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top