Make a query using the necessary tables and joining them as needed. Put the desired fields in the query grid. While still in the query, go to View, Totals. This will add a row called Totals to the query grid. Change the Totals from Group By to Avg. Save your query. Now go to Reports. Create a new report. Select Chart Wizard and base it off the query you just made. Hope this helps!
Thursday, December 17, 2009
How do I average numbers and create a report in Microsoft Access?
how do I average multiple fields (in columns) of numbers and put them in a graph? (in Microsoft Access).How do I average numbers and create a report in Microsoft Access?
Make a query using the necessary tables and joining them as needed. Put the desired fields in the query grid. While still in the query, go to View, Totals. This will add a row called Totals to the query grid. Change the Totals from Group By to Avg. Save your query. Now go to Reports. Create a new report. Select Chart Wizard and base it off the query you just made. Hope this helps!band myspace
Make a query using the necessary tables and joining them as needed. Put the desired fields in the query grid. While still in the query, go to View, Totals. This will add a row called Totals to the query grid. Change the Totals from Group By to Avg. Save your query. Now go to Reports. Create a new report. Select Chart Wizard and base it off the query you just made. Hope this helps!
Subscribe to:
Post Comments (Atom)
Casino Games And RNG Service Providers 2021 - JT Hub
ReplyDeleteWe are 아산 출장안마 proud to 안산 출장샵 present 태백 출장안마 our latest and most popular casino games 화성 출장샵 to 김포 출장샵 JT Rewards® Casino players! Play some of our best slot machines