Year to date by Month

[rickyzicky]

I have a table with 2 fields: DateEntered and Amount.

Simply enough I want to create a report based on the total amount per month and have it display:

Jan $total of [amount]
Feb $total of [amount]
March $total of [amount]
etc....

Current Year Total [total of column]

I would also like to show the previous year in the next column laid out in the same format.
What is the best way to go about it.

The closest I have is a running query (see below)

SumOfAmount Expr2 Expr1
$520.00 2002 1
$615.00 2002 9
$665.00 2003 1
$50.50 2003 2
$207.00 2003 3
$333.00 2003 4
$333.00 2003 5
$216.69 2003 6
$105.00 2003 7
$98.00 2003 8
$5,572.09 2003 9
$946.00 2003 10
$44.00 2003 12

I'd like to extract this info into a report with the above fromat

Any ideas?

Thanks