|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 10th, 2009, 08:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Sumif function in Access
Please help!
I need to sum amounts if a condition applies. The source table has 3 columns: AcctNum, Amount, Category. 123 10 Tax 123 5 Ins 123 8 Loan 123 2 Loan 123 1 Tax There are only 3 categories (tax, insurance, loan), but there can be 1 account number with multiple categories. I need to sum up the categories so the end result looks like: AcctNum Tax Ins Loan 123 11 5 10 Thank you! 
|
|
#2
December 10th, 2009, 08:54 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Sumif function in Access
Check out crosstab queries in Help.
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Hurrikane4" wrote: Please help! I need to sum amounts if a condition applies. The source table has 3 columns: AcctNum, Amount, Category. 123 10 Tax 123 5 Ins 123 8 Loan 123 2 Loan 123 1 Tax There are only 3 categories (tax, insurance, loan), but there can be 1 account number with multiple categories. I need to sum up the categories so the end result looks like: AcctNum Tax Ins Loan 123 11 5 10 Thank you!
|
|
#3
December 18th, 2009, 07:05 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Sumif function in Access
SORRY FOR THE DELAYED RESPONSE!
The crosstab query worked, thank you very much! "Jerry Whittle" wrote: Check out crosstab queries in Help. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Hurrikane4" wrote: Please help! I need to sum amounts if a condition applies. The source table has 3 columns: AcctNum, Amount, Category. 123 10 Tax 123 5 Ins 123 8 Loan 123 2 Loan 123 1 Tax There are only 3 categories (tax, insurance, loan), but there can be 1 account number with multiple categories. I need to sum up the categories so the end result looks like: AcctNum Tax Ins Loan 123 11 5 10 Thank you!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
