age <= 18 from date of birth

[Mike Hughes]

Would someone help me change this query (if it can be done) to select CASE where there are no DEP’s under the age of 18.

A CASE can have more than one DEP


SELECT [1 ALL OPEN CASES].DO, [1 ALL OPEN CASES].WORKER, [1 ALL OPEN CASES].CASE, NOLDBA_INT_CASE_MEMBER.MEMBER_ID AS DEP, NOLDBA_INT_MEMBER_DEMOGRAPHIC.DATE_BRTH AS DOB, = DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],
"mmdd")>Format(Date(),"mmdd"),1,0) AS AGE
FROM [1 ALL OPEN CASES] INNER JOIN (NOLDBA_INT_CASE_MEMBER INNER JOIN NOLDBA_INT_MEMBER_DEMOGRAPHIC ON NOLDBA_INT_CASE_MEMBER.MEMBER_ID = NOLDBA_INT_MEMBER_DEMOGRAPHIC.MEMBER_ID) ON [1 ALL OPEN CASES].CASE = NOLDBA_INT_CASE_MEMBER.CASE_ID
WHERE
[1 ALL OPEN CASES].WORKER ="000GA" AND
NOLDBA_INT_CASE_MEMBER.RELATION_CODE="D"

 

[namliam]

Select *
from ( YourQuery )
Where age > 18


???

 

[Mike Hughes]

reversed, I hadn't thought of that! Thanks!