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.
How to use Countif in Access to count items greater than specific date
Collapse
X
-
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