Art Exhibitions            Index           Links           Home             Feedback

Last                                                                   Next

Community Tute 24 - Calculate survey totals using a query & on a form

1. Start Access and open the database we created in the last tute, select the 'Tables' tab and the 'Main Table' object then hit the 'Open' button. If you did not compete the last tute you can download the database click here to download.


2. create a new query


3. select design mode, go straight to the design mode of the query


4. add the baseline query and add field Q1 through Q11.


5. This is the cel that calculalates the total using the other values in the qurey, TOTAL: [Q1]+[Q2]+[Q3]+[Q4]+[Q5]+[Q6]+[Q7]+[Q8]+[Q9]+[Q10]+[Q11]


6. switch to data sheet mode and view the output


7. save the table as 'Calculate Totals'


8. You can also do the same thing on the form, create a new field (HL) and enter the same string as the control source. Note that this information is not actually stored in the table, it gets calculated in reak time (each time the form refreshes).


9. View the output on the form.





Copyright © 1999 R&D Robotics Pty Ltd, All rights reserved.
Any copyright subsisting in the above code and or literary works including source files vests with R&D Robotics Pty Ltd. ACN 086 345 137


Last                                                                   Next