Help with calculations

[myxmaster]

I have a subform wiwth 3 fields

Date, Transaction, Amount

I would like to sum the amounts by category, for example:

Date Transaction Amount
1/1/06 Deposit 500
1/2/06 Deposit 500
1/3/06 Withdrawal 400
1/3/06 Withdrawal 200
1/7/06 Credit 300

Based on this table the results would reflect

Transaction Amount
Deposit 1000
Withdrawal 900
Credit 300

any help in obtaining the desired result is most appreciated.

 

[myxmaster]

Oops,
Sorry this was posted twice, also withdrawal should reflect 600

 

[John W. Vinson]

I have a subform wiwth 3 fields

Date, Transaction, Amount

I would like to sum the amounts by category, for example:

Date Transaction Amount
1/1/06 Deposit 500
1/2/06 Deposit 500
1/3/06 Withdrawal 400
1/3/06 Withdrawal 200
1/7/06 Credit 300

Based on this table the results would reflect

Transaction Amount
Deposit 1000
Withdrawal 900
Credit 300

any help in obtaining the desired result is most appreciated.

Create a Query based on your table. Select only the Transaction and
Amount fields.

Click the Greek Sigma icon - looks like a sideways M. This will make
the query into a Totals query.

Leave the default Group By on the Transaction field, and change it to
Sum on the Amount field.


John W. Vinson [MVP]