How to use Countif in Access to count items greater than specific date

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rniles01
    New Member
    • Oct 2014
    • 1

    #1

    How to use Countif in Access to count items greater than specific date

    Hello, I have a table listing over 5k rows with a "Completed Date". I want to create a query that will count all the items with a completed date that is greater than 8/31/2014. I tried to start the query by pulling in the table and fields. Then under the "Completed Date" field next to [Criteria] I put ">08/31/2014" and next to [Total:] I selected "Count". This did not work.
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    use an \ aggregate query /
    Click thru, follow the tutorial.
    (site with more detail: \ Count Data Using a Query / )

    If you are still having issues then post your SQL and we'll advise from there... please understand, this is a common homework type question so we need you to show your actual work first (^_^)
    Last edited by zmbd; Oct 8 '14, 03:35 PM.

    Comment

    Working...