Devang has attended:
Access Introduction course
Reports and Forms
When you have designed a report or a form, is there a way to go back to the Wizard and change your personalised settings such as calculations?
RE: Reports and Forms
Dear Devang
Thank you for attending my Access Intro training yesterday.
It was a great pleasure
It does happen that you might decide to change your mind after you have gone through the report wizards step that you didn't want the groups to be Totalled ( Sum) but wanted them Counted or averaged, etc...
The good news is that it is possible and very simple to do so.
Follow these steps please:
Step 1:
Once you have created the report go to the Design view of the report
Step 2:
You'll see the relevant field footed where the function is done. E.g. if you chose sum and the field name was Quantity then it will be something like =SUM([Quantity])
Step 3:
You simply change the function name of your choice. Please bear in mind that in Excel the Function name Average is AVG in Access!! You can type in Count, MIN or Max.
Please do not put any unnecessary brackets or delete any brackets which are already there. ONLY replace the function name.
One more thing to note here is that with every text box (where the Function is created) a label for it appears on the left hand side. So if the Label says TOTAL because originally you chose SUM please remember to change the label to the name of the Function otherwise it might look awkward.
Hope this helps.
If you do enrol for Intermediate or Advanced Access in the future then you'll learn more about these and many other topics.
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
