Show revenue by month problem

[TheOmniJuggler]

Hey everyone,
So my assignment is to create a query that generates the Revenue by Month for 2001 and 2002.
I'm very new to Access, but what I tried to enter was:
In one field, I put: Expr1: Format([order_date],"mmmm yyyy")
With the criteria set to >#12/31/2000# AND <#01/01/2003
The second field I put: Expr2:[line_item_price]*[line_item_quantity]
And put "Sum" as the total.

I'm pretty sure the Expression 2 is correct, but when I run the query nothing shows up. So I'm assuming something is wrong with Expression 1? Any suggestions? Or if you have a better way for me to generate revenue by month, let me know!
Thanks very much!

[pbaldy]

I think you want the criteria on the order_date field, not the formatted field. Change the totals row to Where for that field so it doesn't mess with your grouping. In other words, you'll have 3 fields in the query instead of 2.

[TheOmniJuggler]

Pbaldy,
That worked fantastically! Thank you! One other question, if possible I would like to sort my data in order of when the dates actually occurred, but at the moment I can only get it to sort Alphabetically by month (when I select Sort: ascending/descending). Is there a way to get it to sort by month order instead of alphabetically? Hope that makes sense,
Thanks so much!

[pbaldy]

Try adding another field for sorting:

Format([order_date],"yyyymm")

You can group by that field; it shouldn't change the result.