Guys!

Some tip ? 😀

For example I have a colmn with total of "Motivo", group by "Motivo".

Now I need add a colmn that calculat the percentage.

how ?

Percentage = Count(Motivo) group by "Motivo"

...

Gooa idea 🙂

this is working

tks!

but a saw other situation...

Is possible have two condition in the IIF ?

Thanks rbarryyoung !

I get the solution hehe

was one condition wrong .

Tks again

Ayres

thanks for answer

I Did

SELECT prod.*, B.Bounce AS Bounce, NTF.NTF, (Bounce - NTF.NTF) AS B_Real, ROUND((NTF.NTF/(Bounce)*100),2) AS SDEF, ROUND((B_Real/(prod.ENC)*100),2) AS INDB, ROUND((Bounce/(prod.ENC)*100),2) AS TTB

FROM ([SELECT...

Folks,

I move my query let's see

SELECT teste.tecnico,teste.nome (select sum(teste.qtd) from teste where teste.setor_dest= 'IRMOT' ) AS HF, (select sum(teste.qtd) from teste where teste.setor_dest= 'QCC') AS TT

FROM teste

GROUP BY teste.tecnico,...

Thanks for answer again!

I will wait to news answer hehe

Tks!

Tks for answer

but I don't how why ... when run the query faile!

I'm using BD access, theses comand suport th access?

this query I'm runing in the VB.net hehe

this...