I am trying to build a query in Query Builder, like:
select account, count(account) from General_Ledger group by account
The problem is that I cannot add the account field twice and apply the aggregate function ‘count’ to the second account field.
Query Builder apparently allows only one instance of a field. Is this right?
Of course, I can type the query but some people may want to create it visually, by drag and drop the account field twice, as in MS Access that does not have this limitation.
Is there any way to achieve this functionality?
M.R. Message was edited by: mr2001
Message was edited by: mr2001