I have a query that shows all calls from corporate mobile phones and indicates whether the number called is also a company mobile or whether it is a number in one of the company offices.
When I try to run a totals query based on this:
SELECT Call0InternalSplit.Month, Call0InternalSplit.NrCalled, Call0InternalSplit.CallType, Call0InternalSplit.PartNrCalled, Count(Call0InternalSplit.Charge) AS ChargeOfCount
FROM Call0InternalSplit
GROUP BY Call0InternalSplit.Month, Call0InternalSplit. NrCalled, Call0InternalSplit.CallType, Call0InternalSplit.PartNrCalled
HAVING (((Call0InternalSplit.CallType) Like "Internal")) OR (((Call0InternalSplit.PartNrCalled) Like "1111" Or (Call0InternalSplit.PartNrCalled) Like "2222"));
I get the error message that “you tried to execute a query that does not include the specified expression…..as part of an aggregate function.”
I have researched other questions regarding this issue but have not been able to work out how it relates to my problem.
Could somebody please help?
When I try to run a totals query based on this:
SELECT Call0InternalSplit.Month, Call0InternalSplit.NrCalled, Call0InternalSplit.CallType, Call0InternalSplit.PartNrCalled, Count(Call0InternalSplit.Charge) AS ChargeOfCount
FROM Call0InternalSplit
GROUP BY Call0InternalSplit.Month, Call0InternalSplit. NrCalled, Call0InternalSplit.CallType, Call0InternalSplit.PartNrCalled
HAVING (((Call0InternalSplit.CallType) Like "Internal")) OR (((Call0InternalSplit.PartNrCalled) Like "1111" Or (Call0InternalSplit.PartNrCalled) Like "2222"));
I get the error message that “you tried to execute a query that does not include the specified expression…..as part of an aggregate function.”
I have researched other questions regarding this issue but have not been able to work out how it relates to my problem.
Could somebody please help?