How about doing a pivot table and grouping the date field by month.
--
HTH...

Jim Thomlinson


"Dave M." wrote:

I am attempting to write code for a report that will total outstanding sales
orders dollars for the current month. How can I select the records that only
belong to the current month? Any help would be greatly appreciated.