Hi there.
I try to do something very simple (I think so
).
Using only one table like this.
Client1
Client2
Client3
Client1
cleint1
I want to know
The count of each client - Count(table.client) as "howmany"
Client 1 - 3
Client 2 - 2
Client 3 - 1
The average of those clients --AVG(howmany)
The result must be 2 in this example
And then as final result taht I need to show in an Excel worksheet which are those clientes <= than the average.
Client 2 and client 3 is the result.
The problem is that I can do that in MSQUERY and I dont know why
this is part of the query to solve the first point
SELECT interaccion.Account, Count(interaccion.Account) AS 'Average'
FROM interaccion interaccion
GROUP BY interaccion.Account
HAVING (interaccion.Account<>'')
but when I try to do the rest I cant do it in MSQUETY I obtain several kinds of errors.
Any help is welcome
I try to do something very simple (I think so
).Using only one table like this.
Client1
Client2
Client3
Client1
cleint1
I want to know
The count of each client - Count(table.client) as "howmany"
Client 1 - 3
Client 2 - 2
Client 3 - 1
The average of those clients --AVG(howmany)
The result must be 2 in this example
And then as final result taht I need to show in an Excel worksheet which are those clientes <= than the average.
Client 2 and client 3 is the result.
The problem is that I can do that in MSQUERY and I dont know why
this is part of the query to solve the first point
SELECT interaccion.Account, Count(interaccion.Account) AS 'Average'
FROM interaccion interaccion
GROUP BY interaccion.Account
HAVING (interaccion.Account<>'')
but when I try to do the rest I cant do it in MSQUETY I obtain several kinds of errors.
Any help is welcome
