So i have a table called Resource in SQL in MS ACCESS,which has a field called Resource_Type which has values Permanent and Contract,
what i'm trying to do is get the count of the number of permanent and contract employees so as to display it's ratio.
This is my code,
t1.CntOfResource_Type Where t1.Resource_Type='Permanent' As Perm ,
t1.CntOfResource_Type Where t1.Resource_Type='Contract' As Contract
Count(Resource.Resource_Type) AS CntOfResource_Type
GROUP BY Resource.Resource_Type) AS t1;
When i try to run this code i get an error saying "syntax error (missing operator) in this expression "t1.CntOfResource_Type Where t1.Resource_Type='Permanent' As Perm , "
Does anyone know why?