<div>
&lt;air code&gt;<br />

<pre><code class="code-1 nolinks" id="code-20-40428677-1"><span>SELECT Emp_ID, CASE course_not_completed_count WHEN 0 THEN 'MEETS REQUIREMENTS' ELSE 'DOES NOT MEET REQUIREMENTS' END as requirements</span>
<span>FROM (</span>
<span>   SELECT Emp_ID, </span>
<span>     SUM(CASE WHEN ISNULL(Course_Completed) = 1 THEN 1 ELSE 0 END) as course_not_completed_count</span>
<span>   FROM YourTable</span>
<span>   GROUP BY ID) a</span>
</code></pre>
<br />
btw I have an article out there on <a href="https://www.experts-exchange.com/Database/MS-SQL-Server/A_12366-SQL-Server-CASE-Solutions.html" rel="ugc">SQL Server CASE Solutions</a>, with a wompload of examples, if it helps.
</div>


<div>
So here is my tables that I will be using. &nbsp;the dbo_emp_course.trainingcom<wbr />pl is the table that will store the date. &nbsp;If no Date I need it to store a field that says Does Note Meet Requirements, but if it does Meets requirements.<br />
<br />
SELECT dbo_EMP_Train.EmpID, <br />
dbo_Emp_course.Course_name<wbr />, <br />
dbo_Emp_course.TrainingCom<wbr />pl<br />
<br />
FROM<br />
&nbsp;((dbo_EMP_Train INNER JOIN dbo_JobGroup ON dbo_EMP_Train.PrimaryPosit<wbr />ion = dbo_JobGroup.PositionID)<br />
&nbsp;INNER JOIN dbo_TrainingCourse ON dbo_JobGroup.CourseID = dbo_TrainingCourse.CourseI<wbr />D)<br />
&nbsp;INNER JOIN dbo_Emp_course ON dbo_TrainingCourse.CourseN<wbr />ame = dbo_Emp_course.Course_name<wbr />;
</div>


<div>
I should add that this table could have several rows of courses some with dates and some without dates.
</div>


<div>
example: &nbsp;<br />
<b>dbo_emp_train.empid</b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>dbo_emp_course.course_name<wbr />,</b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>dbo_emp_course.trainingcom<wbr />pl</b><br />
2321 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; training a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/00<br />
2321 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;training b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
2321 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;training c &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/1/00<br />
2400 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; training a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/1/00<br />
2400 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; training b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/1/00<br />
2400 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;training c &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/1/00<br />
<br />
So in this example employee 2321 would be a Does not meet requirements and employee 2400 would be Meets requirements.
</div>


<div>
It is not good practice to store calculated values. &nbsp;Once any one of the underlying records is updated or a new one is added, the calculated value becomes obsolete.<br />
<br />
Did you try the query Jim posted? &nbsp;It is T-SQL syntax and therefore must be run as a pass-through query in Access. &nbsp;If you want something in Access syntax, then the following should do it.<br />
<br />
SELECT dbo_EMP_Train.EmpID, IIf(Sum(IIf(IsDate(dbo_Emp<wbr />_course.Tr<wbr />ainingComp<wbr />l, 1, 0)) = Count(*), &quot;Meets Requirements&quot;, &quot;Does Not Meet Requirements&quot;)<br />
&nbsp;FROM<br />
&nbsp; ((dbo_EMP_Train INNER JOIN dbo_JobGroup ON dbo_EMP_Train.PrimaryPosit<wbr />ion = dbo_JobGroup.PositionID)<br />
&nbsp; INNER JOIN dbo_TrainingCourse ON dbo_JobGroup.CourseID = dbo_TrainingCourse.CourseI<wbr />D)<br />
&nbsp; INNER JOIN dbo_Emp_course ON dbo_TrainingCourse.CourseN<wbr />ame = dbo_Emp_course.Course_name<wbr /><br />
Group by dbo_EMP_Train.EmpID; <br />
<br />
You'll probably want the employee name in addition to the EmpID but you CANNOT add the course names since that would remove the aggregation.
</div>


<div>
<div class="content wysiwyg-content">
Ok I have a table that lists Emp_id, and Course_ID, and Course_completed. &nbsp;Is is possible to generate a query that looks and at all of the courses for that employee and then checks date to see if they have completed all and If they have it will state MEETS REQUIREMENTS else Does not meet requirements.
</div>
</div>


Ok I have a table that lists Emp_id, and Course_ID, and Course_completed.  Is is possible to generate a query that looks and at all of the courses for that employee and then checks date to see if they have completed all and If they have it will state MEETS REQUIREMENTS else Does not meet requirements.

Access Query that looks at results and gives a yes no

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.