Recent content by cool

thank you Grumm I have solved it , I am good with vba but not in SQL .

please ,, an example may be help and forgive me because I don't know what's the meaning of conversion table

that's exactly what I need ,and I wish to do it with vba but I don't know how to start :confused:

Ranman , thanks for the reply there's maybe 20 different job I have to subtract a different values from them I just put these 3 for example , may I ask you for more explanation ?

I have a string variable in vba containing the following SQL : - "SELECT Count(*) AS employ_number, table1.job AS jobs " & _ "FROM (SELECT DISTINCT names, job FROM table1) AS countx " & _ "GROUP BY table1.job " that's worked fine from the above , I have a grouped counts based on job...