Results 1 to 4 of 4

Getting a count within a date range

  1. #1
    mavhendricks is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2019

    Getting a count within a date range

    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!

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    Access (database) is quite different than Excel(spreadsheet). Can you show us your table design? And tell us a little about the data?

    Welcome, and good luck with your project.

  3. #3
    mavhendricks is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Here is a screenshot of the table. I have covered the Employee Names for privacy purposes. (I was having an issue with the image not uploading to the post.)

    The Associates are required turn in a number of conversations each quarter. Sometimes they talk with one person, sometimes more than one. The "Number of Contacts" column tells me how many people they talked to. The "Date of Contact" is the day that they wrote down for the conversation. Then I have the "Spoken To" and "Spoke With". We were letting the person that they talked with get credit for the conversation as well, but that is going away this year.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Nevada, USA
    Post 3 was moderated due to the link. I'm posting to trigger email notifications.
    Paul (wino moderator)
    MS Access MVP

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 07-31-2018, 12:23 PM
  2. Replies: 3
    Last Post: 10-01-2014, 03:09 PM
  3. Replies: 11
    Last Post: 05-09-2014, 11:00 AM
  4. Replies: 3
    Last Post: 07-18-2013, 03:21 AM
  5. Count Dates within Date Range
    By eckert1961 in forum Queries
    Replies: 2
    Last Post: 03-08-2009, 09:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums