In the transactions we have several entries for each category. We create a query which shows the total amount for each category. To do this we use the SUM function. We also look up some queries using the date – after a date or before a date.
|
|
||
Sum In Access QueryIn the transactions we have several entries for each category. We create a query which shows the total amount for each category. To do this we use the SUM function. We also look up some queries using the date – after a date or before a date. |
||
|
Copyright © 2010 Free Microsoft Access Training - All Rights Reserved |
||
