This is my current situation, which I use to produce a report that is grouped by months and weeks of the month...(week 1, week 2, week 3....and so on) I can open a recordset that is based on a table and query and count the number of records that have a date that fall within that range. Once I find the number of records in week 1, I close the recordset and open another recordset to find the number of records within week 2 and so on. Is this the most efficient way to do this? Can you open a recordset and do all the record counting at one time before closing it out? Counting the records that fall within each month is not a problem, but the records within each week is tricky because the way I have to do this based on days that fall within the range from Sunday - Saturday for the month. For example, for the purpose of this report, October 2005 has 6 weeks. Week 1 is 10/1 Week 2 is 10/2 - 10/8 Week 3 is 10/9 - 10/15 Week 4 is 10/16 - 10/22 Week 5 is 10/23 - 10/29 Week 6 is 10/30 - 10/31 Would it be possible to count each of the groups of records from one recordset?