1. Create an account query
2. On the Criteria tab, specify any specific accounts using the field Account > Account number - One of, or leave off if all accounts are desired in the results
3. On the Output tab, expand Summary and select Net Activity
4. Within Net Activity, specify the date range in "Date equals" for the first time period and click Ok
5. Right click the newly added Net Activity field on the right > click Column heading and type in a description for the time period
6. Repeat steps 3 through 5 for any other periods needed to create multiple columns of information
7. On the Sort tab, select a field to sort by, such as account number
8. Select the Results to see the query results