I am very new to building a database, I can do the basic functions. I have created a database for work. Our Associates are required to talk with people (and document the conversation) about safety at least once a week. I then collect the number and report it for the quarter as part of our gain share. In the past I maintained all of this in a spreadsheet, but it has just gotten so big that it has become too time consuming.
I created the form that lets me put it all into a table, I just need a better way to filter it than what I have been doing. Which is to copy it all out to a spreadsheet then filter it that way. Again it is extremely time consuming to do it that way.
I have looked in various places and can't find out what I need with my to do with my query to be able to get a count for each Associate within a certain date range. Any help is greatly appreciated!