Problem Exporting Records Sorted by Month

[WHW]

I have built a db that keeps up with leased printer information..the fields are as follows: <Printer>, <Copies>, <Supplies>, and <Supply Qty>. I also have a field <Entry Date> that auto-enters the creation date of each record. I take a monthly count of each printers' total copies, supplies and their quantities and to send that info to our vendor. I want to export this info from this db and email it instead of writing by hand.

So, my question is: How do I export sorted records for any given month?

[Vaughan]

Create a calculation field "DateMonth" = Month(EntryDate)

The result of this calc will be the month of the date as a number (January = 1, etc).

Sort by this calc field before you export.