Hi,
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,
Select
t1.CntOfResource_Type Where t1.Resource_Type='Permanent' As Perm ,
t1.CntOfResource_Type Where t1.Resource_Type='Contract' As Contract
From
(SELECT
Resource.Resource_Type,
Count(Resource.Resource_Type) AS CntOfResource_Type
FROM Resource
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?
Please help.