Newbies Casi Posted November 30, 2007 Newbies Posted November 30, 2007 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?
Tpaairman Posted December 5, 2007 Posted December 5, 2007 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.
Recommended Posts
This topic is 6202 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now