I am struk with a query and tried a lot
SELECT AUTH.company, Auth.Uc+AUTH.ULL+auth.uca AS AUTH,
Count(AUTH.company) AS Held,
Count(auth.company Not Like pers.duesoutdetails) AS Out,
held-out-auth AS ['Sur/Defi']
FROM (AUTH INNER JOIN PERS ON Pers.company = AUTH.company)
GROUP BY AUTH.company,Auth.uc, AUTH.UL,auth.uca;
the output is as same i required and is also correct calculation
but when i add a caluse as
Count(auth.company Like pers.duesoutdetails) AS Joining
This also gives the same count as OUT this means the count as done for that company row only. then i tried with a separate query
SELECT auth.COMPANY, AUTH.UC+auth.UL+AUTH.UCA AS auth, Count(DuesInOut.COMPANYTo) AS Joining
FROM auth INNER JOIN InOut ON auth.COMPANY = InOut.COMPANYTo
GROUP BY auth.COMPANY,AUTH.UC,auth.UL,AUTH.UCA;
The above query gives me the peoples Joining . I want the all calculations in one gridview output