Access Reports

Hi Dee,

Thank you for your post, sorry it has taken so long to respond, Welcome to the forum.

In answer to your question: Yes you can create calculated values, these are usually displayed on Reports, although you can create them in Queries and then have the resultant field displayed in a Report or Form.

If you are creating a Report and want to create these totals quickly and easily, use the Report Wizard, follow through the instructions and when you come to the Summarize page make your choices as to which fields you wish to Summarise, at this point you can also Create a Total.

If however you wish to create a specific SubTotal and Total you should open the Form or Report in Design view, Create a Text Box (Ab) button. and then using the Build Function create your calculated field.

I hope that has helped, regards Pete