Calculations in report or query

[access2010]

Hello, I am entering tax information that requires calculations into a form.

The calculations are visible and perfect on the form but do not appear in the table for printing.

A - should the calculations be created for each field in the report
B - should the calculations be entered into a Form/Query

Your suggestions are appreciated.

Thanks+

 

[jzwp22]

In general, calculated values should not be stored in the tables, you would just do the calculations on the fly when you need them in a report, form or query. If you require a report, then you would handle the calculations there. It sounds like you already have the calculations functioning in a form which is fine also. Say for example that your users are doing searches and as part of the data set you want some calculated values. Typically you would use a query. In this case, you would include the calculation in the query. I typically pass the query results to a form for easier viewing by the user.

 

[access2010]

Thank you for your suggestion.

Yes the calculation data in the form was working and now the calculations are controled in the Query / Form and Report, which is much easier.

Regards
Paul

 

[jzwp22]

You're welcome