**Weekly membership report**

[John M]

I want to be able to produce a report that counts the number of new members joined in a particular month/week. I have a table tblMembership that records the joining date. How can I use this information to produce a such a report.

 

[Rich]

The easiest way is to add the required fields to a query, set the criteria for the date field to Between[EnterStartDate] And [EnterEndDate]. The query will return only those records between the chosen dates.
HTH

 

[John M]

Yes it does. TAL.