November 30, 200718 yr Newbies I need to create a report that shows by month how many inquiries were received in each month. Not quite sure how to approach this?
December 5, 200718 yr Not much info to go on, but I'm assuming that each inquiry is a new record. If so create a new field called Count. Make it a number whenyou create it, then go the the options and under Auto-Enter go to the box for data and enter a 1. What happens then is that field will always have a number 1 in every record. I'm not sure how you are displaying your monthly results, but you can do a summary of that field - the summary will add up every 1 for the found records and give you a total.
Create an account or sign in to comment