I have a query based on my Contact Table and Gift Table. It shows the ContactID from the Contact Table, Brochure Request Date from the Contact Table (criteria between 1/1/1999 and 1/31/1999), Gift ID from the Gift Table, Date of Gift from the Gift Table ("First" in total line), Amount of Gift from the Gift Table ("First" from total line). Running the query gives me two contact ID's who do not have a Gift ID; therefore, gave no gift after requesting a brochure. It also shows the Contact ID of those who requested a brochure in that date range who gave a gift after the request.
I want a report to count how many Contact ID's there were in January 1999, how many in February 1999, how many in March 1999, etc. I need no details or dollar amounts. Just to know there were 11 people who requested the brochure between 1/1/1999 and 1/31/1999 who gave first gifts in January of 1999, 6 who gave first gifts in February of 1999, etc.
Is there an easier way than creating separate queries from the main query to count each month - then create the report to show the numbers?
Any suggestions are greatly appreciated.
Thanks for your time.
Julie