M
Michael Nagan
My data looks something like this:
Date Job ID Expense
1/1/07 1 $100
1/2/07 1 $50
1/3/07 2 $75
1/4/07 1 $500
1/5/07 3 $200
I'd like to be able to sort by date and break/group on job ID. If I were to
sum expense, I'd like to end up with:
Job ID Expense
1 $150
2 $75
1 $500
3 $200
I'm looking for a simple way to accomplish this, hopefully in a query.
Thanks.
Michael
(e-mail address removed)
Date Job ID Expense
1/1/07 1 $100
1/2/07 1 $50
1/3/07 2 $75
1/4/07 1 $500
1/5/07 3 $200
I'd like to be able to sort by date and break/group on job ID. If I were to
sum expense, I'd like to end up with:
Job ID Expense
1 $150
2 $75
1 $500
3 $200
I'm looking for a simple way to accomplish this, hopefully in a query.
Thanks.
Michael
(e-mail address removed)